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

What is the use of partition by in sql?

925

What is the use of pl/sql table?

996

what are the advantages of using stored procedures? : Sql dba

1058

What is the main reason behind using an index?

964

Is sql port 1433 encrypted?

968

Is sql a oracle?

910

Do we need to create index on primary key?

851

what is the command used to fetch first 5 characters of the string? : Sql dba

1584

Why is stored procedure faster than query?

906

What packages are available to pl/sql developers?

991

Why we use sql profiler?

907

Can I create table without primary key?

937

How can you view the errors encountered in a trigger?

914

Is mariadb a nosql database?

1004

how to rename an existing table in mysql? : Sql dba

1002