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

Answer Posted / tejas wajge

create table emp as select * from project where rownum <1;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by query optimization?

540


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

4502


What is difference between sql and oracle?

554


Enlist the data types that can be used in pl/sql?

566


What does trigger mean in slang?

518






How to run pl sql program in mysql?

505


how to use in conditions? : Sql dba

503


Can we create foreign key without primary key?

525


Does sql view stored data?

528


What are the differences between in and exists clause?

558


Is a view faster than a stored procedure?

540


What are the ddl commands?

528


Can we edit a view in sql?

540


what is isam? : Sql dba

566


What is sql and how does it work?

540