I have a small PL/SQL Block
assume in this way
begin
select * from emp where empno=100;
exception
when others then
<Some Messages>
when no_data_found then
<Some Messages>
when too_many_rows then
<Some Messages>
end;
The question which he asked was whether this block will get
executed normally or it will throw error ?
If errored out then what is the reason for the error ?
Could anybody please help me ?
Regards
Nakul Venkataraman
- 3 Answers
- 7579 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / virendra
yes this will give error, as in exception block when others
should be at the bottom of the exception block.
ex.
exception
when no_data_found then
<Some Messages>
when too_many_rows then
<Some Messages>
when others then
<Some Messages>
end;
| Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
How many tables can a sql database have?
How do I find duplicates in sql?
What is a primary key sql?
Show the cursor attributes of pl/sql.
Which nosql database is best?
What is benefit of creating memory optimized table?
What is a left join?
How do you sort in sql?
Why we use join in sql?
Does group by remove duplicates?
How to change sql*plus system settings?
What do you know by pl/sql cursors?
What is the purpose of the partition table?
What is percent sign in sql?
What is %type in sql?
