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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to invoke the data pump export utility?

777


material view and view disadvantages?

808


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

3551


How to write date and time interval literals in oracle?

756


How can windows applications connect to oracle servers?

712


What are the various types of snapshots ?

770


Explain the use of analyse option in exp command.

776


Is there any function in oracle similar like group_concat of mysql?

795


What is oracle analytical function?

740


How to save query output to a local file?

779


How to create a new view in oracle?

832


Explain the difference between replace() and translate() functions in oracle?

793


What is java oracle used for?

764


what is a Nested Loop join?

1789


How index is implemented in oracle database?

766