NULL = NULL ...NOT TRUE NO ROWS RETURNED 1=1 ...TRUE ALL ROWS RETURNE

what is the output of select * from emp where null=null &
select * from emp where 1=1

Question Posted / chandana

8 Answers
19191 Views
IMS Health, NIIT, I also Faced
E-Mail Answers

Answer Posted / chandana

NULL = NULL ...NOT TRUE
NO ROWS RETURNED

1=1 ...TRUE
ALL ROWS RETURNED

1=2....NOT TRUE
NO ROWS RETURNED

2=2,3==3 AND SO ON WILL RETURN ALL ROWS FROM A TABLE

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to display row numbers with the records?

1061

How to bring a tablespace online?

1060

What are the different types of failures that occur in Oracle database?

1047

What is an oracle?

994

What are the different editions of oracle?

1089

How to retrieve data from an cursor to a record?

1073

How many categories of data types in oracle?

1007

What is a synonym? What are its various types?

1093

What are the built-in functions used for sending Parameters to forms ?

3358

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1673

What is oracle rownum?

930

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2211

What are the execution control statements in oracle?

1066

How to drop an index in oracle?

1051

How to write text literals in oracle?

1056