what is the output of this query selet * from employee
where 1=2 ??
Answer Posted / ashokkumar
create table temp_employee as select * from employee where 1=2;
this is only for a correct answer..
it is create from a temporary table in same table name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use threading in pl/sql?
How to pronounce postgresql?
What is pragma in pl sql?
What are sql commands?
Is a secondary key the same as a foreign key?
How to run sql statements with oracle sql developer?
which operator is used in query for pattern matching? : Sql dba
What is group by in sql?
What is a sql instance vs database?
How to run pl sql program in mysql?
When is a declare statement required?
How do I find duplicates in a single column in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is the difference between union and union all command?
What do you understand by pl/sql packages?