create table emp as select * from project where rownum <1;

How can I create a table from another table without copying
any values from the old table?

Question Posted / tejas wajge

Answer Posted / tejas wajge

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to test for null values?

983

Does truncate need commit?

893

how to return query output in html format? : Sql dba

1021

Which are sql * plus commands?

1039

Does google use sql?

912

What is indexes?

999

How would you reference column values before and after you have inserted and deleted triggers?

1016

How do you modify a trigger?

874

What is procedure in pl sql?

978

What does where 1 1 mean in sql?

978

What packages(if any) has oracle provided for use by developers?

5716

explain advantages of innodb over myisam. : Sql dba

1082

What is case function?

987

What is aggregate function in sql?

984

How do I partition a table in sql?

1041