Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of the query select * from emp where 1=2
- 10 Answers
- 42543 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
Q) Create Preffered customer: As a customer when i purchase more than $5000 in goods since my first purchase, I become a preffered customer so that i can receive the benefits associated with that status.
What is the role of the test group vis-?is documentation, tech support, and so forth?
What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?
What is pesticide paradox?
Build with fixes has been deployed on QA environment if asked by your manager to reproduce how can you reproduce the issues? (by using the previous build) Can you access the previous build? If so ,what are the tools or how can you access?
HI GUYS,, I HAVE 3 YEARS OF EXP IN MANUAL TESTING...NEXT MONTH ONWARDS I WORK FOR MOBILE TESTING....PLS SUGGEST ME WHAT I LEARN FOR TRAING,, MOBILE TESTING OR ANDROID....FOR MOBILE TESTERS NEED ANDROID(IFONE) DEVOLOPMENT KNOWLEDGE OR NOT? EXPLAIN CLEARLY
On what basis you are fixing up the time for project completion?
What is the test harness?
Which testing model is best as per your understanding, and why?
How do you know the code has met specifications?
wht is Manual Testing Frame work
How do you test for the coockies for a web application?
What are the two main categories of software testing?
How is ‘build’ different from ‘release’?
Hi Friends, I want to know the best institute in hyderabad which is giving training in 'SAP Testing' and who is the best faculty. Regards, Imtiyaz..
