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 |
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What is the oracle implicit cursor?
Is it possible to disable the parameter from while running the report ?
what r tyhe major differences between oracle 9i & 10g?
Can we write insert statement in function in oracle?
What are the uses of synonyms?
How would you go about verifying the network name that the local_listener is currently using?
What is indexing, and how does it improve performance?
Can a formula column referred to columns in higher group ?
Explain the use of rows option in imp command.
What do database buffers contain?
What is different bet native dynamic sql and Dbms_Sql?