Oracle/SQL Question

From: Lehner Eveline <a9325237_at_unet.univie.ac.at>
Date: Fri, 17 Apr 1998 11:25:46 +0200
Message-ID: <3537201A.708B0871@unet.univie.ac.at>

Problem:
Does anyone know of a way to store the result of a (dynamic!) Select-Statement in a table? Because I need to know the names of the selected attributes. And I also like to make queries to the result-table.

I've tried to use:
- CREATE TABLE .... AS SELECT .... (but it's not possible to use
ORDER BY)
- the package DBMS_SQL (but there's no way to get the names of the
attributes)
- write the result table in a text-file and then read it again into a
table (not the easiest way!)

Question:
Is there no simple statement in (PL/)SQL?

Thanks in Advance
Eveline Lehner
Vienna, Austria Received on Fri Apr 17 1998 - 04:25:46 CDT