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 |
What are the logical operations?
How to write a query with a right outer join in oracle?
How to put more than 1000 values into an oracle in clause?
What is the difference between hot backup and cold backup in oracle?
How to use attributes of the implicit cursor in oracle?
how to clone 9i Database on to 10g Database.
What is procedure overloading in oracle?
Difference between an implicit & an explicit cursor.?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is a database schema in oracle?
How to run create database statement?
What is sequence?