what is the output of the query select * from emp where 1=2
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
Hi, i am looking job in perfomance testing using Loadrunner can any body help me a project in any domine plz(Usah) chs_29@rediffmail.com
What are the bugs we cannot find in black box?
When should you opt for manual testing over automation testing?
few automation basic questions One question to write a scriot in any language you know.
Can anybody help i put the pharma and bank project in my resume, but i dont know what to tell about them, any body tell the where can i get the information about them,what i need to tell about these applications,please help me
What is desk checking and control flow analysis
Is an "A fast database retrieval rate" a testable requirement?
To specify the test artifacts involved in testing.
I HAVE AN INTERVIEW IN A SOFTWARE COMPANY FOR THE POST OF FUNCTIONAL TEST ENGINEER. THEY WANT THE PERSON FROM BCOM BACK GROUND( I AM A BCOME GRADUATE 2006) AND THE PERSON SHOULD HAVE GOOD ACCOUNTS KNOWLEDGE. NOW I WANT TO KNOW WHAT KINDS OF QUESTIONS THEY CAN ASK OR CAN GIVE IN WRITTEN TEST. I M NERVOUS COZ ITS BEEN 5 YEARS I HAVE DONE BCOM. SO HOW SHUD I PREPARE FOR INTERVIEW.PLEASE HELP? reply me pls. its urgent. thanks
How could you present test strategy for the product testing?
test measurment techniques
Should testing be done only after the build and execution phases are complete?
What is the Myers Boundary Table?
Hi, I was asked following question during a interview. Please answer it: Password field is there,we can accepts every character except underscore and semicolon. It can accept min 6 characters and maximum 12 characters. Prepare boundary value and equivalence class test cases.
hi everybody, iam Adi Durga, i complited my bsc(computers) in 2008.I have experience in finacial and bpo companys(mnc). but iam intersted on s/w role.I have the technical skills c, c++, Oracle 9i and manual testing. But i dont know hoe to strat my career in s/w. Every company offering on financial/bpo side. In this I attended nearly 10 companies,I selected in 8. All those are bpo and finacial, But i cant get any opportunities on s/w side.plz help how to get opportunites on s/w side. Actually I am interested on testing side. But every company offering for only experienced persons. plz help me. this is my mailid.... adi.durga19@gmail.com