SELECT * INTO emp1 from scott.emp where rownum=0

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

Question Posted / atul verma

Answer Posted / atul verma

SELECT *
INTO emp1
from scott.emp where rownum=0

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of triggers?

1022

What are the types of keys?

981

What is trigger in sql?

1068

Give the order of sql select?

1120

What is sql injection owasp?

1039

What is the difference between a query and a report?

950

What is query optimization in sql?

967

What is cursor and why it is required?

1165

What is cte sql?

971

What is the advantage of nosql?

1043

What is equi join in sql?

1057

What is the use of index in sql?

995

How do you use collections in procedure to return the resultset?

2229

What is sql in oracle?

1044

Why do we need a foreign key?

1073