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...


what is the difference between no rows returned and null
returned?

Answers were Sorted based on User's Feedback



what is the difference between no rows returned and null returned?..

Answer / sagar

no rows selected maens there is no matching rows for that
particuler query

null value when we searching for value which is null

Is This Answer Correct ?    7 Yes 1 No

what is the difference between no rows returned and null returned?..

Answer / suman rana

No rows returned will raise Oracle Exception NO_DATA_FOUND,
but Null returned will not raise this exception

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is oracle used for?

0 Answers  


Difference between varchar and varchar2 data types?

0 Answers  


How to write numeric literals in oracle?

0 Answers  


3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers   Wipro,


How do I call oracle stored procedures that take no parameters?

0 Answers  


Can a Tablespace hold objects from different Schemes ?

3 Answers  


what are the differen between key flexifild and discriptive fiexifild.

1 Answers  


what is query and types of query

6 Answers   Reliance,


Which dictionary tables and/or views would you look at to diagnose a locking issue?

0 Answers  


What is a package in oracle?

0 Answers  


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

0 Answers  


What is the dynamic sql in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)