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 is pivot table in sql?
What is sql character function?
What is offset and limit in sql?
how to add a new column to an existing table in mysql? : Sql dba
Why is sql*loader direct path so fast?
How do I start sql from command line?
What is use of trigger?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is trigger and stored procedure in sql?
How do you declare a user-defined exception?
what are ddl statements in mysql? : Sql dba
What is sql and explain its components?
How do you create a db file?
How run sql*plus commands that are stored in a local file?
Is pl sql better than sql?