Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is a scalar value in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is a boolean in sql?
How do you use collections in procedure to return the resultset?
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...
When are we going to use truncate and delete?
Can a table have no primary key?
How do I make my sql query run faster?
What is a table partition?
what is msql? : Sql dba
how can we optimize or increase the speed of a mysql select query? : Sql dba
What are different types of sql commands?
Is drop table faster than truncate?
Are left and right joins the same?
What is transaction control language (tcl)?
