create table based on a select statement

[mbl73]

Is it possible to use multiple tables in the select statement when creating tables?

 

[BJCooperIT]

Yes, did you try it?

CREATE TABLE mytable AS
(SELECT d1.dummy, SYSDATE my_date, 
        d2.dummy extra_col
 FROM dual d1, 
      dual d2);

SELECT * FROM mytable;

DUMMY   MY_DATE                 EXTRA_COL
X       03/29/2007 10:16:27 AM  X

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com

 

[mbl73]

I am new to oracle so my questions may seem very basic.
I did try it but used GLOBAL TEMPORARY TABLE instead, should that matter?