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 nosql db?

547

Can we rollback delete command?

516

Does sql backup shrink transaction log?

556

How to check if a column is nullable before setting to nullable?

586

What are the types of keys?

516

Can we use pl sql in sql server?

541

Why is sql*loader direct path so fast?

603

What is primary key and unique key?

547

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1646

What is a scalar value in sql?

590

what are the different type of sql's statements ? : Sql dba

522

Does sql full backup truncate logs?

533

What is where clause in sql?

537

what are the advantages a stored procedure? : Sql dba

553

how do you login to mysql using unix shell? : Sql dba

568