MariaHalt
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
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!
select * into <new table> from <existing table> where something is something;
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER