Which of the following is not a valid Oracle PL/SQL exception? - ProProfs Discuss
Topics
Products
Follow Us:

Which of the following is not a valid Oracle PL/SQL exception?

Which of the following is not a valid Oracle PL/SQL exception?

Change Image    Delete



A. NO_DATA_FOUND ORA-01403
B. TWO_MANY_ROWS ORA-01422
C. DUP_VAL_ON_INDEX ORA-00001
D. OTHERS
E. None of the above. These are all valid.

This question is part of EASY ORACLE PLSQL QUIZ
Asked by Ibecruzin, Last updated: Feb 22, 2020

+ Answer
Request

2 Answers

H. callum

Extrovert, Psyched all the time.

H. callum, Content Writer, BA, Birmingham, Albama

Answered Feb 07, 2019

The correct answer to this question is D.

In PL/SQL, an error condition is called an exception. Exceptions can be internally defined (by the runtime system) or user defined. Examples of internally defined exceptions include division by zero and out of memory. Some common internal exceptions have predefined names, such as ZERO_DIVIDE and STORAGE_ERROR. The other internal exceptions can be given names. You can define exceptions of your own in the declarative part of any PL/SQL block, subprogram, or package.

For example, you might define an exception named insufficient_funds to flag overdrawn bank accounts. Unlike internal exceptions, user-defined exceptions must be given names.

 

John Smith

John Smith

Answered Apr 07, 2017

TWO_MANY_ROWS ORA-01422

TWO_MANY_ROWS is not the correct name for the TOO_MANY_ROWS exception
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.