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
What do you mean by query optimization?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is difference between sql and oracle?
Enlist the data types that can be used in pl/sql?
What does trigger mean in slang?
How to run pl sql program in mysql?
how to use in conditions? : Sql dba
Can we create foreign key without primary key?
Does sql view stored data?
What are the differences between in and exists clause?
Is a view faster than a stored procedure?
What are the ddl commands?
Can we edit a view in sql?
what is isam? : Sql dba
What is sql and how does it work?