Answer / ravi148

it retrives on coulmn names ie., does not show any records..

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

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.

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

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

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.

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

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

Answer / prasad237

it will display all the columns

Answer / sekhar

null value

What is Tracebility Matrix ? What is there in that and what will u do with that ?

15 Answers   CTS, Polaris,

By using any techinique in tesing......how to find the greatest number between 1-10.?

2 Answers  

What are the Validation Testers? Their responcibilities? Are Manual tester & Validation testers are same?

2 Answers  

what is meant by system testing? what is functional testing? what is the difference between both of these testing? can anyone explain this in detail?

5 Answers  

Is anybody have the telecom systems test cases from start to end?

0 Answers   Netsoft,

How can we do security testing while testing a project

4 Answers   Oracle,

what documents are used to write testcase for integration testing and system testing?

3 Answers  

for example, if we have a textbox ranging from 0-100. which methodology we are using & what are inputs we are observed?

1 Answers   Semantic Space,

What is the difference between QA (Quality Assurance) & QA (Quality Analyst)?

4 Answers  

what is test data?how test data is prepared? are there any guidelines/methods to prepare it?

4 Answers  

How will you link the Defect to the Test case? Explain Bug life cycle ?

1 Answers   Crea,

What is Black Box testing and who is responsible for Black box testing?

18 Answers   TCS,