Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Explain the use of parfile option in exp command.

1012

How do we get field details of a table?

943

What is blob data type in oracle?

1061

What privilege is needed for a user to connect to oracle server?

960

What are the limitations of check constraint?

976

How to rename a column in an existing table?

989

How to grant create session privilege to a user in oracle?

955

What are the system predefined user roles?

994

Is oracle the best database?

934

How to create a stored function in oracle?

1058

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2224

What are the four Oracle system processes that must always be up and running for the database to be useable?

968

What is an Oracle index?

1617

Explain what are the uses of rollback segment?

975

Is there a function to split a string in plsql?

1003