"NODATAFOUND" and "TOOMANYROWS" are the errors found when executing a SELECT statement - PL/SQL

Q.  “NO_DATA_FOUND” and “TOO_MANY_ROWS” are the two most common errors found when executing a SELECT statement. (PL/SQL)
- Published on 26 Jun 15

a. True
b. False

ANSWER: True
 
The “NO_DATA_FOUND” error is where the program is not able to find any data. This type of error can be trapped by the exception block.
The “TOO_MANY_ROWS” error is where one row data is conflicting with another row data so it is unable to fetch a particular data. This error too can be trapped by the exception block.

Related Content

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲