Interested to Buy Any Domain ? << Click Here >> for more details...
select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 5572 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the limitations of check constraint?
How to synchronize 2 schema's objects?
How to define an explicit cursor in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is the difference between data migration and production migration.
What is the disadvantage of User defind function?
How to loop through data rows in the implicit cursor?
How to add a new column to an existing table with a default value?
How to update values in a table in oracle?
What is a package in oracle?
Give syntax for SQL and ORACLE joins.
Difference between varchar and varchar2 data types?
Why we use bulk collect in oracle?
What is the implicit cursor in oracle?
What are temporal data types in oracle?
