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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2794


What do you understand by a database object?

788


How to add a new column to an existing table with a default value?

771


Why do you create or replace procedures rather that drop and recreate.

747


What is a partition in oracle?

779


Why does oracle 9i treat an empty string as null?

740


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

778


Explain an exception and its types?

807


List out the components of logical database structure of oracle database.

792


What is a cursor and what are the steps need to be taken?

790


What is a directory object?

830


What is the Tune Query

2060


What do you understand by database schema and what does it hold?

934


What are the various types of snapshots ?

771


How many types of database triggers exist?

760