Performing queries on nested tables.

From: <juturi_at_workmail.com>
Date: Wed, 08 Sep 1999 20:58:53 GMT
Message-ID: <7r6im5$2th$1@nnrp1.deja.com>

(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 Wed Sep 08 1999 - 15:58:53 CDT