Nested table!

How can I include a column that exists in a nested table in a where
condition? I want to return the filtered nested table without unsetting
it. Below is my table.

Table 1

Col1    Col2            Col3 (Nested Table)
=3D=3D=3D=3D    =3D=3D=3D=3D            =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
1       X               see below Col3 Row 1


Col3 (Row 1)

colA    colB    ColC    ColD
=3D=3D=3D=3D    =3D=3D=3D=3D    =3D=3D=3D=3D    =3D=3D=3D=3D=3D
1       2       3       4
1       3       4       4
3       4       5       6


This is the type of query I would like to do, but I don't know if it is
possible.

SELECT *
FROM Table 1
WHERE Col1 =3D 1
AND Col3.ColA =3D 1

The return from the query should be the following:

1       X               (1, 2, 3, 4), (1, 3, 4, 4)=20


Thanks,
San
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  • » Nested table!