What are pl/sql exceptions? Tell me any three.
Answer / kiran r
An Exception is error handling part when ever error occurs exception raises.
Exceptions are classified as
1. Predefined Exception
2.User defined exception
some of predefined Exceptions are:
NO DATA FOUND, TOO MANY ROWS, CURSOR ALREADY OPEN, INVALID CURSOR, INVALID NUMBER, ZERO DIVIDED
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the uses of control file.
explain the difference between myisam static and myisam dynamic. : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
What is use of trigger?
Explain what is dbms?
Can we insert data in view?
display your age in months?
What are the PL/SQL Statements used in cursor processing ?
what is a database lock ? : Sql dba
Why truncate is faster than delete?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?