Link to home
Start Free TrialLog in
Avatar of brgdotnet
brgdotnetFlag for United States of America

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;
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of brgdotnet

ASKER

Thanks !