Roelf
08-06-2003, 12:34 PM
in sql server i can do:
select *
into temptable
from existingtable
sqlserver then creates the temptable and copies the existingtable (structure and data) to the temptable.
how can i achieve this in oracle??
select *
into temptable
from existingtable
sqlserver then creates the temptable and copies the existingtable (structure and data) to the temptable.
how can i achieve this in oracle??