nested tables - SQL

all:

i have a column in a table which in turn is a table. using the latest oracle nested table stuff.. what is the SQL
statment to compare values of this field.

eg:

CREATE or REPLACE type my_type
AS OBJECT
        ( type_name INTEGER );

CREATE or REPLACE type nest_table
AS table of my_type;

my table CONTAINER has columns {

        name varchar(32)
        nest   nest_table
      }

now, how do i write a sql to get all rows in table CONTAINER, where type_name is value 0

i tried
select name from CONTAINER where nest.type_name = 0;

it doesnt work..

appreciate any help.

madhu Received on Mon Mar 17 2003 - 17:14:47 CST