var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to copy a table to a new table without creating it manually
Microsoft SQL Server allows you to copy an existing table to a new table without creating it manually. For example:
The new_authors table will have the same data definition as the authors table.
insert into new_authors
select * from authors
Is there similar functionality in Oracle 10g?
creating new table
create table new_table as
select * from old_table
Note that none of the constraints (except the NOT NULL one), indexes or triggers will be created using that statement.
No problem. I'm just looking for a quick way to make a backup copy of data. SQL Server doesn't create constraints, indexes, etc. with its syntax either.
Originally Posted by Littlefoot