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 |
How to connect to a remote server?
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)
How to count groups returned with the group by clause in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are triggers?Where are they used?
How does the on-delete-cascade statement work?
What is the data pump import utility?
What is a Private Synonyms ?
What is connection pooling in oracle?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Name the three major set of files on disk that compose a database in Oracle?