Answer / tulsi

The PRAGMA EXECPTION_INIT tells the complier to associate
an exception with an oracle error. To get an error message
of a specific oracle error.

e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error
number)

Answer / harish

Oracle have some builtin errors but they have only error
code not the error name user can define this builtin errors
by using Pragma EXECPTION_INIT

What is input buffer in sql*plus?

0 Answers  

---

Differentiate pl/sql and sql?

0 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

Does pdo prevent sql injection?

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---

Why does %isopen return false for an implicit cursor?

1 Answers  

---

What are different types of refreshment techniques of materialised view

2 Answers  

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

Are left and right joins the same?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

Is natural join same as inner join?

0 Answers  

---