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

Explain normalization and what are the advantages of it?

603


Write the command to remove all players named sachin from the players table.

820


What is pls_integer in pl sql?

636


Is pl sql a programming language?

633


What are the methods of filing?

596






GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2671


What is sql comments?

735


what are the advantages and disadvantages of views in a database? : Sql dba

637


What are sql triggers used for?

611


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

578


What is the difference between subquery and correlated query?

627


What is sql and also describe types of sql statements?

642


Could you please provide oca (oracle 10g) dumps for my certification ?

4643


How to find 3rd highest salary of an employee from the employee table in sql?

655


Mention what is the use of function "module procedure" in pl/sql?

689