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
Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: www.EmuProductsPlus.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.