Link to home
Start Free TrialLog in
Avatar of MariaHalt
MariaHaltFlag for United States of America

asked on

Oracle quick table creation

Remember, I'm new to Oracle.  In my old MS SQL Server world I could quickly create a table with

select * into <new table> from <existing table> where something is something;

Open in new window


How can I quickly do the same in Oracle (without having to look up all the field data types)?

It's not for stuff that is going to persist.  Just 'temporary'.  Does Oracle have an equivalent to MS SQL's # tables?  That would be super.  Please advise.  Thank you.

BTW, I do Google stuff, but I just want a straight answer to my question.  I feel sometimes I get sucked into rabbit holes when I try searching the interwebs!
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

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
SOLUTION
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
SOLUTION
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 MariaHalt

ASKER

Thanks!