Hi,

I have a table as follows

create table inters (
OUTLET_ID VARCHAR2(2 CHAR),
SKU_ID VARCHAR2(2 CHAR))
/

I have created the follwing type

CREATE OR REPLACE
type obj as
object (sku1 varchar2(2));

the nested table is as follows.

CREATE OR REPLACE
type nst as
table of obj;

My Query is
SELECT OUTLET_ID,CAST(MULTISET(
SELECT SKU_ID
FROM INTERS
WHERE OUTLET_ID = N.OUTLET_ID) AS NST) RR
FROM inters N

Now my problem is, i want to use the column RR in
the above query in my where clause.

How do i do it ?

Any help would be of great use.

Thanks