create table sunil as select *from hr.employees

How can I create a table from another table without copying
any values from the old table?

Question Posted / sunil panghal

Answer Posted / sunil panghal

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we use joins in subquery?

1143

Is left join inner or outer by default?

1006

How to use boolean type in select statement?

1051

How do I sort a table in sql?

1021

Does sql*plus have a pl/sql engine?

1053

What is right join sql?

951

What are the three pl sql block types?

987

how can we submit a form without a submit button? : Sql dba

963

How to connect a sql*plus session to an oracle server?

1113

What is rename command in sql?

1004

How does left join work in sql?

985

Write the alter statement to enable all the triggers on the t.students table.

1112

What is serial sql?

956

How do you delete duplicates in sql query using rowid?

928

How many columns should be in an index?

951