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 happens if the update subquery returns multiple rows?
What is an oracle wallet?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the components of logical database structure in oracle database?
How do I escape a reserved word in oracle?
What are the predefined tablespaces in a database?
What is a cursor in oracle?
How to find the date and time of last updated table?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
What is an oracle cursor variable?
What is raw datatype?
what is insert all statement in sql