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

Answer Posted / sunil panghal

create table sunil as select *from hr.employees

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between sql and mysql?

545


what is the use of double ampersand (&&) in sql queries?

617


What is flag in sql?

531


Is sql a oracle?

519


What is trigger and how to use it in sql?

529






What is sql partition?

545


Can delete statement be rollbacked?

519


Explain 3 basic parts of a trigger.

826


What is query execution plan in sql?

557


How to change the order of columns in Oracle SQL Plus ?

606


how to include numeric values in sql statements? : Sql dba

554


What is difference between inner join and cross join?

514


What are instead of triggers?

614


Why stored procedure is better than query?

501


What is the purpose of design view?

517