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
How many types of functions are there in sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is compiled query?
What is difference between rank () row_number () and dense_rank () in sql?
what is error ora-03113: end-of-file on communication channel?
What is sql character function?
Is big data nosql?
Can a commit statement be executed as part of a trigger?
what is unique key constraint? : Sql dba
What are aggregate and scalar functions?
Why do we use joins in sql?
How many disk partitions should I have?
What is pl sql record in oracle?
Explain what is a subquery ?
What are the types of optimization?