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

how to enter characters as hex numbers? : Sql dba

1024

What are the advantages of pl sql?

1106

what is the difference between inner and outer join? Explain with example. : Sql dba

1013

What is package in pl sql?

1000

Is nosql faster than sql?

1000

What's the difference between inner join and left join?

984

Can we call a function containing dml statements in a select query?

960

How do I debug a stored procedure?

1095

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2209

how can we repair a mysql table? : Sql dba

956

What are different types of sql commands?

1094

What is the maximum rows in csv?

911

What are the advantages of pl sql over sql?

1011

Can unique keys be null?

883

what is a table in a database ? : Sql dba

1024