1.statament "no rows select" 2.statament "the 14 rows disp

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

Question Posted / bhavish

Answer Posted / bhavish

1.statament "no rows select"
2.statament "the 14 rows displayed
why because the true condition and null values are different

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1934

How do I spool to a csv formatted file using sqlplus?

1038

How will you write a query to get a 5th rank student from a table student_report?

1866

What is the difference between alert log file and tarce file ?

2172

What is dynamic proxy?

1011

What are the extensions used by oracle reports?

1039

Explain joins in oracle?

1038

What happens to the indexes if a table is recovered?

993

How to check the server version in oracle?

1094

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2626

What is private procedure oracle?

1013

What happens if you use a wrong connect identifier?

1069

How do I limit the number of rows returned by an oracle query after ordering?

1170

Difference between open_form and call_form in oracle.

1164

Can you drop an index associated with a unique or primary key constraint?

1022