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
- 16372 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 the difference between the repeatable read and serializable isolation levels? : Transact sql
Does a primary key have to be a number?
What is meant by user defined function?
Is left join faster than inner join?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What programs use sql?
What is scalar function?
Is left join faster than join?
What is a behavioral trigger?
What are the different types of triggers?
define sql insert statement ? : Sql dba
What is minus?
Do we need to create index on primary key?
Why do we need pl sql?
How can a function retun more than one value in oracle with proper example?
