1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / chandana

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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1829

How many categories of data types in oracle?

605

What is merge in oracle?

561

Explain what does a control file contain?

608

What is the parameter mode that can be passed to a procedure?

574




How to save query output to a local file?

563

How to experiment a data lock in oracle?

597

What is memory advisor in Oracle?

636

What is the difference between sharding and replication?

479

What are the predefined tablespaces in a database?

556

What is set verify off in oracle?

577

How do I find the database name in oracle?

601

How to view the data files in the current database?

592

What is a initialization parameter file in oracle?

584

Why oracle is used?

580