Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |