Wednesday, October 13, 2010

Quickest way to create a table in Oracle

I found this very easy and quick to create a table, though sort of copy a table to another table.

The syntax is:

create table table_to_create as select * from source_table where 1=0

Hope you find this a little bit of help.

No comments: