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
- 8728 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
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is a native sql query?
Is there a 64 bit version of ssms?
How do you modify a trigger?
What are different types of queries in sql?
What is a unique key?
How to use transactions efficiently : transact sql
What is the file extension for sql database?
What are the types of join in sql?
What is a database trigger?
What is the use of prepared statement?
What are the different types of dbmss?
What is integrity in sql?
What is difference between inner join and self join?
What is oracle sql called?
