In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
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 |
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
Find all employees in Dept “Marketing”.
How to end the current transaction in oracle?
List out the types of joins.
IS it possible to built the oracle database without setting the kernal parameters?
master table and child table performances and comparisons in Oracle ?
What is a subquery in oracle?
what are the disadvantages of hierarchial database over RDBMS?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How are the index updates?
how to store only time in a data base table
what are Triggers?