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
- 8866 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 stored procedure faster than query?
Is vs as in pl sql?
How do I start sql from command line?
Why do we use triggers?
What does subquery mean in sql?
what is a relationship and what are they? : Sql dba
What is trigger explain it?
Why do we create views in sql?
What are the two characteristics of a primary key?
Which query operators in sql is used for pattern matching?
What is pl sql in oracle?
Does truncate require commit?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Why do we need view in sql?
what is the difference between nested subquery and correlated subquery?
