what is the output of the query select * from emp where 1=2
- 10 Answers
- 39680 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mithun
hi everyone ,
its a trick to copy the structure of the table wthout the
data .
1 SQL> create table employee1
2 as select * from emp
3 where 1=2;
the compiler will look for the statment 2 first
then it will come to the 3 line to check the condition ,when
it gets a 0 [means false] at that time only the table
structure was there in the buffer ; now it will return to
the 1st statement to create a table with the structure only .
so it will return only the structure of the table .
similarly when this
SELET *
FROM EMP
WHERE 1=2;
querry is executed as per the false conditon it will only
show no rows selected .
hope you get the answer .
have a nice time for any more assistance you can mail me to
ermithun.c@gmail.com
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
Did you ever worked with B.A's and when?
Is an "A fast database retrieval rate" a testable requirement?
What is an exit criteria?
What is client server application testing?
What is smoke testing and user interface testing ?
What is defect cascading in software testing?
How to do integration testing on duster......
what is the technical challange you faced in your module.please ans me the question i just want example can me any example please very important
Which test cases are written first: white boxes or black boxes?
Difference between Stakeholder and Relevant Stakeholder?
Hi there, I am new to the world of testing. Is there any place where I can have a look at an actual specification documents or test plans or test cases. This will help me in generating a level of confidence. Looking forward to your replies
What is virtual creation tool?
What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?
1.How to maintain the Bug status Report? 2.What is project based Company and product based company?
Hello can anybody list out supported and unsupported browsers for Window OS,Android OS,MAC OS Ubuntu
