How can I create a table from another table without copying
any values from the old table?
Answer Posted / atul verma
SELECT *
INTO emp1
from scott.emp where rownum=0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the uses of a database trigger?
How to add, remove, modify users using sql?
What are the basic techniques of indexing?
What is graph sql?
What is a design view?
Can we use delete in merge statement?
what is a control file ? : Sql dba
Can we edit a view in sql?
How does sql*loader handles newline characters in a record? : aql loader
How do I write a cron which will run a sql query and mail the results to agroup?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Explain aggregate functions are available there in sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is a natural join?
What is the current version of sql?