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

How to connect to a local oracle 10g xe server?

528


What are the uses of Database Trigger ?

1097


Explain the use of show option in imp command.

638


Is oracle a relational database?

519


What is not equal to in oracle?

526






What are the uses of linked server and explain it in detail?

584


What are the set operators union, union all, minus & intersect meant to do?

560


What is a directory object?

586


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1363


what is difference between sql plus and sql*plus? (not sql and sql plus).

3342


What is the use of file param in imp command?

642


How to end the current transaction in oracle?

549


How to estimate disk space needed for an export job?

558


Explain the difference between a procedure and a function? What do you understand by those terms?

618


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1799