How to create a table similar to the output of a query?
Posted: Tue Apr 08, 2008 6:50 am
Hi All
How we can create a table similar to the output of query?
Suppose we want to create a table TAB1
and I have a query like
Select * from Table2
Can I write a query like
CREATE TABLE TAB1 AS
SELECT *
FROM Table2
How we can create a table similar to the output of query?
Suppose we want to create a table TAB1
and I have a query like
Select * from Table2
Can I write a query like
CREATE TABLE TAB1 AS
SELECT *
FROM Table2