Answer Posted / 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 |
Post New Answer View All Answers
Can I call a procedure inside a function?
What is primary key secondary key alternate key candidate key?
Does varchar need length?
explain access control lists. : Sql dba
Which normal form is best?
Can ddl statements be used in pl/sql?
what is an index? : Sql dba
Which is the correct statement about truncate and delete?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is normalisation and its types?
Is sql a microsoft product?
Where is pl sql used?
What are sql indexes?
What is on delete set null?
Explain the savepoint statement.