select statement does not retrieve any records. what
exception is raised?
Answers were Sorted based on User's Feedback
Answer / madhu
Here two ways is there
you are using single select statement it display no rows
selected message.
If you are using in PL/SQL BLOCK at that time it raise the
error
NO_DATA_FOUND( IF YOU DECLARED) OTHER WISE IT GO FOR
WHEN OTHERS_THEN EXCEPTION HANDER.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is oracle thin client?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What are the original export and import utilities?
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.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
how to make an oracle object
How to convert characters to dates in oracle?
write a query that displays every Friday in a year with date?
How to commit the current transaction in oracle?
how to select second mauximum value in a given table under salary column
What are the components of physical database structure in the Oracle database?
How to connect to the server with user account: sys?