Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to create view for a table containing a nested table?
You are going to need to write a Pl/SQL procedure to to fashion a query
returning columns from the main table and columns from the nested table.
lkw <lkw_at_axiomatique.com> wrote in message
news:8a7336$afd$1_at_newton.pacific.net.sg...
> 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
![]() |
![]() |