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

Explain the uses of a database trigger?

1086

How to add, remove, modify users using sql?

1089

What are the basic techniques of indexing?

1111

What is graph sql?

1039

What is a design view?

978

Can we use delete in merge statement?

1099

what is a control file ? : Sql dba

1089

Can we edit a view in sql?

1041

How does sql*loader handles newline characters in a record? : aql loader

1090

How do I write a cron which will run a sql query and mail the results to agroup?

1029

how to create a new table by selecting rows from another table in mysql? : Sql dba

1166

Explain aggregate functions are available there in sql?

1049

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1272

What is a natural join?

1140

What is the current version of sql?

1068