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

what are the nonstandard string types? : Sql dba

1138

How to prepare for oracle pl sql certification?

1066

What is trigger point?

996

what is clause? : Sql dba

1063

Is pl sql useful?

994

What are the sql aggregate functions?

1133

What is keys and its types?

1075

What is trigger in pl sql?

1002

Why we use triggers in mysql?

992

Why is partition used in sql?

1123

How to run pl sql program in mysql?

1020

What are local and global Indexes and where they are useful.

1444

What are secondary keys?

971

What is not null in sql?

1057

Write a sql query to get the third highest salary of an employee from employee_table?

1073