what is the difference between no rows returned and null
returned?
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 |
How to use subqueries with the exists operator in oracle?
How to connect to oracle using service name instead of sid?
How to use windows user to connect to the server?
What is the use of oracle?
How to test null values?
How to insert a record into a table?
How do I limit the number of rows returned by an oracle query after ordering?
what is difference between cartesian join & cross join even they give same result?
How to define an oracle cursor variable?
Select the Nth lowest value from a table?
What language does oracle use?
How to get execution statistics reports on query statements?