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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/03/10
Message-ID: <952733092.3367.0.nnrp-09.9e984b29@news.demon.co.uk>#1/1

In 8.1 you can do the following:

select c.*, a.*
from

        customer c,
        table(c.address) a

But should I assume from the appearance of the THE() operator that this is 8.0

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

dgpare wrote in message ...


>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 Fri Mar 10 2000 - 00:00:00 CST