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
- 8870 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
Name three sql operations that perform a sort.
What is oracle sql called?
What are the different set operators available in sql?
What is index example?
How do you bind variables in pl sql?
what are dynamic queries in t-sql? : Transact sql
Why is normalization important?
What is time based sql injection?
how to check myisam tables for errors? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
What is right join in sql?
What is an inner join sql?
can sql servers linked to other servers like oracle? : Sql dba
what is cross join? : Sql dba
How to revise and re-run the last sql command?
