Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9032 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
Is primary key is clustered index?
What is %rowtype in pl sql?
what is denormalization. : Sql dba
What are the different types of functions in sql?
Which command is used to call a stored procedure?
How do I make my sql query run faster?
Which is faster union or join?
How does left join work in sql?
How can you save or place your msg in a table?
What is sql constant?
How do we use distinct statement? What is its use?
What are the types of views in sql?
explain the difference between bool, tinyint and bit. : Sql dba
What are the uses of sysdate and user keywords?
Can a table contain multiple primary key’s?
