Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to create view for a table containing a nested table?

how to create view for a table containing a nested table?

From: lkw <lkw_at_axiomatique.com>
Date: 2000/03/09
Message-ID: <8a7336$afd$1@newton.pacific.net.sg>#1/1

hello all,

say now i have one table 'customer' and inside 'customer' there is a nested table name 'address' storing all address info. to select record information from 'customer' table, i always need to perform 2 sql statements.

select * from customer;
select * from the(select address from customer);

so, i was trying to create a view that allows me to do a single sql statement but performing the same tast as the 2 sql statements above.

so how shall i write the script to create the view?

your help would be greatly appreciated!! This problem has been with me for at least 2 weeks!
thanks...

lkw. Received on Thu Mar 09 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US