what is the difference between no rows returned and null
returned?
- 2 Answers
- 4501 Views
- I also Faced
- E-Mail Answers
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 raw datatype in oracle?
How to define a sub function?
How to bring a tablespace online?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
what is cartesian product?
what is port in oracle? how is it related to database application.
What is a oracle database?
12. Display the client name in upper case only and in lower case only.
What is format trigger?
What is archive log in Oracle?
What is the data pump export utility?
Can we create trigger on view in oracle?
Oracle General 
