Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
1. What will you get by the cursor attribute SQL%FOUND? It returns the Boolean value TRUE if at least one row was processed. 2. What will you get by …
Read More »PL/Sql Interview Questions Part 4
Daily Archives: June 7, 2017
PL/Sql Interview Questions Part 3
1. What are some predefined exceptions in PL/SQL? A list of predefined exceptions in PL/SQL: DUP_VAL_ON_INDEX ZERO_DIVIDE NO_DATA_FOUND TOO_MANY_ROWS CURSOR_ALREADY_OPEN INVALID_NUMBER INVALID_CURSOR PROGRAM_ERROR TIMEOUT _ON_RESOURCE STORAGE_ERROR LOGON_DENIED VALUE_ERROR etc. 2. What …
Read More »