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
- 42538 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arun
Since we are using SELECT statement for this query,
We can view only the structure of the table. where as if we
use the create query we can copy the structure of the table.
| Is This Answer Correct ? | 24 Yes | 6 No |
Answer / anfal
Hi
When i tried the below query in oracle9i it says no rows
selected. could you please let us know in which version of
Oracle u tried this query.
SQL> select * from emp where 1=2;
no rows selected
| Is This Answer Correct ? | 17 Yes | 2 No |
Answer / ganesh
for sure it will display no rows selected
coz for select * from emp give all and because of the where
clause 1=2.......no point in time 1 is eual to 2 or 2 is
equal to 1....so it returns no row.
eg 1=2 ----give no rows
1=1 ---gives all rows
come out of oracle and think as simple logic (is 1=2)....if
yes true else false.....similar of oracle also
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / 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 |
Answer / suresh kumar somayajula
Hi Anfal,
Try the following Query.
SQL> CREATE TABLE EMP_NEW
AS
SELET *
FROM EMP
WHERE 1=2;
Table Created
SQL> SELECT * FROM EMP_NEW
no rows selected.
SQL> DESC EMP_NEW;
Structure will be displayed.
Please correct me if any mistakes.
Thank you,
Suresh
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / vikas patil
It is used only for condition checking
for example select * From emp Where 1=2;
it will return 0 rows
select * From emp Where 1=1;
it will return all rows
select * From emp Where 1<2;
it will return all rows
select * From emp Where 1<=1;
it will return all rows
| Is This Answer Correct ? | 2 Yes | 0 No |
user A done some changes for a portion of test case doc. And user B also done some changes to same portion. If user-A checks in his file first then user-B. Then what is the state of that file?
what is the difference between the severity and priority and tell me high severity and low priority ,low severity and high priority ,high severity and high priority ,low severity and low priority
If there is dropdown field say Select Category. & Default category is Indian. What are the test cases for this field?
Do submit teststrategy to customer if yes at what time
0 Answers Kanbay, Miracle Solutions,
what type of testing techniques are using after accept the build?
hai friends i need a general test cases for check box,drop down button and radio butoon can anybody reply me plz..........thanks in advance
Hi,frnds. can any one tel me " is QUALITY CENTER & TEST DIRECTOR are same or different ? if different, pls tel me the difference.. its an question asked me in an interview.. pls tel me frnds
what are the types of android applications?
Difference between postponed and deferred bug
difference between QA, QC
What is the difference between stub & Driver? which is needed in Top Up & Bottom Down Testing?
(questions asked in interview)hi every one can any one please answer to this questions.these questions were asked in an interview.i have another interview next week . 1.when the time schedule is tight how will you approch the testing,and the relese is nearing and we need to finish testing how can we follow in that case.do we need to exicute all the test cases or can priortise and leave some to next relase. 2. when a new feature is added to the existing application we need to add new test cases but after that do we need to change all the existing test cases and while running do we need to exicute entire application test cases or only the new feature test cases and related new feature test cases. 3.do you have any situation where you have to write and exicute the test cases same time, how will you follow.does it happens in real time. 4.example of bug which is not reproducible.like tester say that there is bug and developer say no can some example of such bugs. 5.during regression testing some times do we need to add new some additional test cases to test that bug.
Automation Testing 
