Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Problem
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
Received on Fri Apr 17 1998 - 00:00:00 CDT
![]() |
![]() |