Re: PL/SQL Problem

Lehner Eveline <a9325237_at_unet.univie.ac.at> wrote:

>I would like to save the result of a (dynamic!) select-statement in a
>table, because I would like to access the attribute-names.
>I've tried it with DBMS SQL but is there a possibility to get the name
>of the attributes? That would be very important.
>
>CREATE TABLE ... AS SELECT ... just allow subqueries (no ORDER BY!).
>
>Thanks for any help!
>Eve
>

Try

Create VIEW.... As Select ..... From Table ...... Where.....Order By..

Then Query the view....

Hope it helps,
John Greco
Oracle DBA
Email to john.greco_at_dot.state.mn.us Received on Fri Apr 17 1998 - 09:11:40 CDT