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 using in sql?

1091

What is a schema sql?

1152

What is orm in sql?

1046

Can a trigger call a stored procedure?

1070

Can we perform dml in function?

1067

how many values can the set function of mysql take? : Sql dba

986

What is oracle and pl sql?

1118

what is the difference between inner and outer join? Explain with example. : Sql dba

1025

What does desc stand for?

1067

How can you get sql*loader to commit only at the end of the load file? : aql loader

1012

What is the default isolation level in sql server? : Transact sql

1023

How does a self join work?

1121

How does postgresql compare to "nosql"?

1029

What are the different sql languages?

1035

How do I save a sql query?

1012