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
- 8903 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
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is the max nvarchar size?
what is a control file ? : Sql dba
what is innodb? : Sql dba
explain about mysql and its features. : Sql dba
What are % type and % rowtype?
What is varchar sql?
Do we need commit after truncate?
What is the difference between a database and a relational database?
What is partition by in sql?
What is the difference between cluster and non-cluster index?
What are aggregate functions in sql?
What are the types of subqueries?
What is right join in sql?
How do I write a cron which will run a sql query and mail the results to agroup?
