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
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is an exception in pl/sql?
What are conditional predicates?
Which data type is a composite type?
How to use sql statements in pl/sql?
What is file based approach?
What is percent sign in sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
How many row comparison operators are used while working with a subquery?
How many clustered indexes can you have?
What are the sql commands?
Is sqlite free?
How to execute a stored procedure?
What is the maximum number of rows in sql table?
how to select unique records from a table? : Sql dba