what is the output of the query select * from emp where 1=2

Answer Posted / vijay amresh

Hi
When i tried the below query in oracle9i it says no rows

SELET *
FROM EMP
WHERE 1=2;

gives the query for 1=2, it is false so There is no row.

But if it runs for 1=1, then all rows are selected.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different strategies for rollout to end users?

730


what is the function generator?

1702


plz send the test scenarios and test cases for "user name should contain 4 to 8 chars and they should have only vowels"

1741


which sanity testing is performed?

1186


On what basis you are fixing up the time for project completion?

783






how to connect your project in database?

1525


aplitue questions will be based on wich type ?

2104


What are the disadvantages of manual testing?

660


What are the bussiness scenories?

2648


is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?

1997


When will the testing starts?

673


What do you think the role of test-group manager should be? Relative to senior management?

1671


What is the difference between functional testing and integration testing?

715


3.if a questions asked as,what is the quality standards you are following? what i need to tell.

1365


Iam new to testing field and i put lot of experiences so i want to get prepared for the interview in all the ways both in manual and Automation can any one help me how to answer there questions in real time. also can anyone send the top questions and answers to me plz its urget u can mail me at vaisu72@yahoo.com

1462