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 |
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
How to drop an index in oracle?
What is a relational database management system?
How to assign values to variables?
Is insert autocommit in oracle?
Can I create users through internet explorer in oracle 10g?
Describe Referential Integrity ?
How to define default values for formal parameters?
Explain the use of ignore option in imp command.
How would you design a database for an e-commerce website?
What is a nvl function?
What is catalog in Oracle?