SELECT * INTO emp1 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 / atul verma

Answer Posted / atul verma

SELECT *
INTO emp1
from scott.emp where rownum=0

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which table is left in left join?

956

Can we write ddl statements in functions?

1054

What is equi join in sql?

1010

Why use subqueries instead of joins?

1034

Is sqlite free?

907

Which language is used in sql?

992

What is the source code of a program?

1005

Is sql an operating system?

963

What are the two types of periodical indexes?

886

How many postgresql users are there, worldwide?

994

Which are the different types of indexes in sql?

992

How long does it take to learn pl sql?

1001

How to select random rows from a table?

1023

Is vs as in pl sql?

935

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1098