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 join two tables in a single query using oracle?
How to open a cursor variable?
Why should I use oracle database?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
what is the difference between UNION AND UNIONALL
What do you mean by a deadlock?
How to use subqueries in the from clause in oracle?
What is hash cluster in oracle?
What is the difference between view and materialized view in Oracle?
How to rollback the current transaction in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are data pump export and import modes?