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 are the t string functions available in tsql? : Transact sql

1063

How to return an array from java to pl/sql?

1181

What is application trigger?

1055

What is a relationship and what are they?

1226

How many aggregate functions are available there in sql?

1018

What are the types of dbms?

1021

Is grant a ddl statement?

943

What is a string data type in sql?

1100

What is difference between hql and sql?

1165

What are the types of variables use in pl sql?

1090

What are the topics in pl sql?

1023

How to get list of all tables from a database?

1209

What is implicit cursor in pl sql?

1146

Is sql microsoft?

1106

What are schema-level triggers?

1151