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 |
what is query cache in mysql? : Sql dba
Can we insert delete data in view?
Which command is used to delete a trigger?
Why are aggregate functions called so?
How many aggregate functions are available there in sql?
Is it possible to create the following trigger: before or after update trigger for each row?
What is full form of rtm?
What are pl/sql cursors?
What is difference between rank () row_number () and dense_rank () in sql?
What are the different tcl commands in sql?
how to check server status with 'mysqladmin'? : Sql dba
I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...