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

Name some usages of database trigger?

1083

What is mdb stand for?

1057

what is denormalization. : Sql dba

1160

what are set operators in sql? : Sql dba

1106

How to install oracle sql developer?

1096

what is commit? : Sql dba

1124

How are sql commands classified?

1143

is mysql query is case sensitive? : Sql dba

1163

Why primary key is required?

1043

Is full outer join same as cross join?

1013

how to convert character strings to numeric values? : Sql dba

1163

Is it possible to pass parameters to triggers?

1159

What is union and union all keyword in sql?

1109

what are the different tables present in mysql? : Sql dba

1040

What is difference between procedure and trigger?

1020