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 does plv msg allows you to do?

0 Answers  

---

what is sql server agent? : Sql dba

0 Answers  

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

0 Answers  

---

What is foreign key and example?

0 Answers  

---

What is cross join sql?

0 Answers  

---

what is the use of set statement in tsql? : Transact sql

0 Answers  

---

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---