Interested to Buy Any Domain ? << Click Here >> for more details...
what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 16463 Views
- CMC, eicc, I also Faced
- E-Mail Answers
Answer Posted / thirumal
select * into <new table name> from < old tablename> where
<any false condition>
ex: new table name "emp"
Old table name "dept"
select * into emp from dept where 2=5
then it will display only the structure of the old
table,not the data
| Is This Answer Correct ? | 3 Yes | 15 No |
Post New Answer View All Answers
What is native sql query?
Is join and inner join the same?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Mention what does the hierarchical profiler does?
What is a sql trace file?
What are the types of subqueries?
What is left join in sql?
Is primary key an index?
What are inner outer left and right joins in sql?
Can we create a trigger on view?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What does pragma mean?
What is meant by truncate in sql?
what are the different functions in sorting an array? : Sql dba
How to read/write files from pl/sql?
