Interested to Buy Any Domain ? << Click Here >> for more details...
In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
- 2 Answers
- 12690 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subba
When Others exception needed to be handled last. If we use
When Others first, and then other exceptions, following
error will be prompted:
ORA-06550: line 8, column 3:
PLS-00370: OTHERS handler must be last among the exception
handlers of a block
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
| Is This Answer Correct ? | 38 Yes | 1 No |
Answer / uma
If we use when others first all the exceptions will be
caught by this block even when specific exception blocks
are present after that.Also no compiler error will be thrown
| Is This Answer Correct ? | 9 Yes | 16 No |
What is instant client oracle?
How to define a sub function?
What are the major difference between truncate and delete?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
Is there a combination of "like" and "in" in sql?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
From the database level, how can you tell under which time zone a database is operating?
How to view the dropped tables in your recycle bin?
a query to select maxmun 3 salaries of employee table
How to define and use table alias names in oracle?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
How to add another datafile to a tablespace?
Oracle General 
