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 is oracle used for?
Difference between varchar and varchar2 data types?
How to write numeric literals in oracle?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
How do I call oracle stored procedures that take no parameters?
Can a Tablespace hold objects from different Schemes ?
what are the differen between key flexifild and discriptive fiexifild.
what is query and types of query
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is a package in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is the dynamic sql in oracle?