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 a segment?

1018

How to work with data objects interactively?

923

ABOUT IDENTITY?

2005

What is an oracle and why it is used?

1077

What are the ways tablespaces can be managed and how do they differ?

2270

Briefly explain what is literal? Give an example where it can be used?

973

What is a sub query and what are the different types of subqueries?

1072

what is the difference between substr and instr function in oracle?

1033

What is rowid and rownum in oracle?

951

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

2183

What is oracle instant client?

970

What is partitioned table in Oracle?

1103

Will you be able to store pictures in the database?explain.

928

What suggestions do you have to reduce the network traffic?

899

How to load a large xml file?

1002