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
- 9038 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / kavitha nedigunta
yes this will give error,
1.need to include the into clause.
(PLS-00428: an INTO clause is expected in this SELECT
statement)
2.as in exception block when others
should be at the bottom of the exception block.
(PLS-00370: OTHERS handler must be last among the exception
handlers of a block)
| Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
what are wild cards used in database for pattern matching ? : Sql dba
What is the basic form of sql query?
Explain the order of sql statement execution?
What is procedure and function in sql?
How do I remove sql plus from windows 10?
What happens when a trigger is associated to a view?
What mean sql?
how to shutdown mysql server? : Sql dba
How can the performance of a trigger be improved?
Is pl sql different from sql?
How long will it take to learn pl sql?
What is the difference between between and in condition operators?
Mention what is the use of function "module procedure" in pl/sql?
what is a record in a database ? : Sql dba
What is index example?
