Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> how to create view for a table containing a nested table?
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
![]() |
![]() |