brgdotnet
asked on
Creating a query from a table
In Sql server I can create a table dynamically using a select into statement from another table. So basically the target table ends up having the exact same column names as the source table. So my "MY_NEW_TABLE" is created dynamically.
Question : How do I do the exact same thing in Oracle?
Example: Sql Server : SELECT * INT MY_NEW_TABLE FROM MY_EXISTING_TABLE;
Question : How do I do the exact same thing in Oracle?
Example: Sql Server : SELECT * INT MY_NEW_TABLE FROM MY_EXISTING_TABLE;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER