Create Table via SELECT statement, can I ? [message #286187] |
Thu, 06 December 2007 16:07  |
icm63
Messages: 22 Registered: December 2007
|
Junior Member |
|
|
I am from MS SQL world. I could create a table via a SELECT statement like this...
MS SQL : SELECT <Field>,<Feild> INTO <DestinationTable> FROM <SourceTable>
What Can I do with PLSQL, can I do the same thing >
|
|
|
|
|
|
Re: Create Table via SELECT statement, can I ? [message #286264 is a reply to message #286232] |
Fri, 07 December 2007 01:11   |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Although Barbara and Ana told/showed you how to do this in Oracle, I think a word of warning would be in place here.
In SQLServer/Sybase, often intermediate results from SQL are stored the way you describe. Then another (series of) SQL-query is fired against this new table
This is _not_ how we do it in Oracle. In Oracle we tend to stuff it all in one big SQL. Oracle is GOOD in joining and doing complex SQL.
|
|
|
|
|