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 difference between a having clause and a where clause? : Sql dba

1073

give the syntax of grant and revoke commands? : Sql dba

1147

Why do we need view in sql?

978

How many types of normalization are there?

955

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

1634

What is the use of sql trace?

947

What is difference between db2 and sql?

996

What is delimiter in pl sql?

1053

How you improve the performance of sql*loader? : aql loader

1009

Which is better join or inner query?

1035

Differentiate between pl/sql and sql?

1143

What is the maximum number of triggers, you can apply on a single table?

989

What has stored procedures in sql and how we can use it?

1070

How can you fetch common records from two tables?

1055

how can we know the number of days between two given dates using mysql? : Sql dba

1044