what is the difference between no rows returned and null
returned?
- 2 Answers
- 4503 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is the string concatenation operator in oracle?
what is a Nested Loop join?
How to load data through external tables?
Explain the use of rows option in exp command.
What is Redo Log Buffer in Oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to start an oracle instance?
How do I learn what codesets are available in oracle?
Can we create trigger on view in oracle?
Explain integrity constraint?
What is backup in Oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Oracle General 
