In Exception handling if we are using the when others first
then what happens . whether it will show the compiler error
- 2 Answers
- 11494 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 |
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
Explain constraining triggers.
Is it possible to disable the parameter from while running the report ?
What is control file used for?
How to convert a date to char in oracle? Give one example.
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
How can we find the size of a database?
What is a view and how is it different from a table?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What would you use to improve performance on an insert statement that places millions of rows into that table?
Oracle General 
