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
- 8731 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 can we know the number of days between two given dates using mysql? : Sql dba
What is a sql trace file?
Can ddl statements be used in pl/sql?
Is crud a cuss word?
What is bind variable in pl sql?
What is the cause of mutating table error and how can we solve it?
Does sql use python?
What are the advantages of sql?
How do you write an index?
How to prepare for oracle pl sql certification?
When is the update_statistics command used?
Does inner join remove duplicates?
what is 'mysqlcheck'? : Sql dba
Explain clause in sql?
How is a process of pl/sql compiled?
