Answer Posted / shaik
Pragma Exception is a pre-compiled exception which is
particularly used to raise the user defined exceptions along
with the ORACLE error code.
PRAGMA EXCEPTION_INIT(exception_name, -Oracle_error_number);
ANY FURTHER CLARIFICATION CALL TO ME :09972372227
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Can we join same table in sql?
What is the clause we need to add in function body to return variable?
Can we call dml statement in function?
What is pl sql commands?
What are database links used for?
explain access control lists. : Sql dba
What is a database? Explain
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
How to run pl sql program in mysql?
What is procedure in pl sql?
How does postgresql compare to mysql?
Name the different types of indexes in sql and define them.
Mention what pl/sql package consists of?
write an sql query to find names of employee start with 'a'? : Sql dba
