Interested to Buy Any Domain ? << Click Here >> for more details...
select statement does not retrieve any records. what
exception is raised?
- 2 Answers
- 5528 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 is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Differentiate between function and procedure in oracle.
Explain the use of rows option in imp command.
What is Reduced List of Values?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
State the various uses of dbcc command?
How to use null as conditions in oracle?
What do you mean by cdb and pdb in oracle 12c?
Why is oracle so popular?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to delete all rows a table in oracle?
Can we create trigger on materialized view in oracle?
What are the logical operations?
What are the varoius components of physical database structure of oracle database?
What happens if you use a wrong connect identifier?
