Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of this query selet * from employee
where 1=2 ??
- 11 Answers
- 18471 Views
- I also Faced
- E-Mail Answers
Answer Posted / julien
indeed it will return o rows, but the goal behind is to
create a new table t2 as select * from t1 where 1=2, where
just the structure of table t1 will be copied without
copying data from table t1.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
How do I find duplicates in two columns?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is pl sql commands?
What is the difference between rollback and rollback to statements?
what is the difference between clustered and non clustered index in sql? : Sql dba
How many types of tables are there?
Is sql scripting language?
what is dbms? : Sql dba
What is package in pl sql?
what is difference between delete and truncate commands? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
Can you upgrade sql express to full sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is the difference between rename and alias?
What is integrity in sql?
