REPOST: PLease help with querying nested tables.

                    (Oracle8i, Red Hat Linux 6.0 Intel x86.)

                    Hi,
                    I have a table as follows:

                    create type phone_objtyp as object
                    ( location varchar2(10),
                    area_code number(3),
                    prefix number(3),
                    suffix number(4),
                    extension number(5))


                    /


                    CREATE TYPE phone_ntabtyp AS TABLE OF phone_objtyp


                    /


                    create table users
                    (userid number(15) not null,
                    username varchar2(15) not null,
                    email varchar2(100),
                    dob date not null,
                    phones_ntab phone_ntabtyp,
                    status varchar2(1),
                    constraint users_pk1 primary key (userid),
                    )
                    NESTED TABLE phones_ntab store as user_phones_ntab


                    /




                    How do I search for all users with phone numbers
with a particular area
                    code (eg. 408)?
                    Please help.
                    Thanks
                    -Juturi

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 09 1999 - 00:41:50 CDT