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
- 42928 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
after completeing testing ,what would u deliver to the client?
What is Registry?
Why it is recommended to add verification checks to your all your scenarios?
How to do manual testing of a E-insurance project (end to end process)
What is an end-to-end testing?
Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?
Explain the importance of agile testing?
hai friends, I need clarifications for some doubts in testing terminology. 1.What is thread testing. 2.What is bucket testing and which automated tool is used to do this test. 3. ERP testin automation testing. 4.What is Data Warehousing testing? 5.What is Implementation testing? 6.What is Shake out testing? please let me have the clarifications in detail
what are the risk factors in the project? what is the base for testplan and entry criteria ,exit criteria for test plan?
In manual testing, what are stubs and drivers?
Write the test cases for yahoo home page
what r the 5 major defects that u found in ur shopping related project?
What are the cases why parameterization is necessary when load testing the Web server and the database server?
how will we change the server system time?
Give me an example of something you tried at work but did not work out so you had to go at things another way.
