Pragma Exception is a pre-compiled exception which is particularly used to

What is pragma exception and how, when, where us

Question Posted / shaik

5 Answers
15156 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Can 2 queries be executed simultaneously in a distributed database system?

1079

Can dml statements be used in pl/sql?

1018

What are the set operators in sql?

1027

How do you use a while loop in pl sql?

939

Why do we need unique key in a table?

882

Explain the significance of the & and && operators in pl sql.

949

what is foreign key? : Sql dba

966

what is sql server agent? : Sql dba

1027

What is rownum?

923

What is cte?

923

Can we write dml inside a function in sql server?

897

How do you exit in sql?

1061

What is difference between my sql and sql?

995

What is the difference between left outer join and left join?

942

How do I upgrade sql?

946