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

Does oracle use sql?

884

What is a dynamic query?

981

What is the trigger in sql?

910

What is Histogram?

1516

How do you update a table in sql?

939

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1057

Is t sql a programming language?

1012

Are sql database names case sensitive?

944

How do I enable sql encryption?

975

What is rownum in sql?

976

Explain the working of primary key?

1046

Can we alter stored procedure?

949

What view means?

935

Explain 3 basic parts of a trigger.

1264

Explain what is dbms?

999