create table emp1 as select * 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 / srinivas

Answer Posted / srinivas

create table emp1
as
select * from scott.emp where rownum=0

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Whis is not false in primary key?

1457

what is sub-query? : Transact sql

1108

how to include comments in sql statements? : Sql dba

962

Which is faster joins or subqueries?

991

Explain ttitle and btitle.

1123

Explain the uses of a database trigger?

1044

What is the use of & in pl sql?

1046

What are basic techniques of indexing?

1385

How do you write a subquery?

1032

How many types of sql are there?

986

Can we rollback truncate?

1001

What is procedure and function in sql?

1003

Is sql a dbms?

1017

Does truncate release storage space?

1083

How to place comments in pl/sql?

1161