Answer Posted / hr@tgksolutions.com
Predefined exceptions in PL/SQL include:
• NO_DATA_FOUND: Raised when a SELECT statement returns no rows.
• TOO_MANY_ROWS: Raised when a SELECT INTO statement retrieves multiple rows.
• DUP_VAL_ON_INDEX: Raised when attempting to insert a duplicate value into a specific index.
• ZERO_DIVIDE: Raised when dividing by zero.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get each name only once from an employee table?
How do I access sql anywhere database?
What is raid? How does it help storage of databases?
What is multiple partition?
How does stored procedure reduce network traffic?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
How many types of keys are there in sql?
Define concurrency control. : Transact sql
what is data integrity? : Sql dba
what are all the common sql function? : Sql dba
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
what tools available for managing mysql server? : Sql dba
What is the current version of postgresql?
what is acid property in database? : Sql dba
Why do we use view in sql?
