Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between no rows returned and null
returned?
- 2 Answers
- 5562 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 privilege is needed for a user to create tables in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Is it possible to insert comments into sql statements return in the data model editor ?
When system tablespace is created?
What is difference between cartesian join and cross join?
What is an oracle recycle bin?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is Read-Only Transaction ?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is a nested table?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Oracle General 
