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 memory optimized?

0 Answers  

---

What are sql procedures?

0 Answers  

---

How do you pronounce sql?

0 Answers  

---

What are basic techniques of indexing?

0 Answers  

---

what are the t string functions available in tsql? : Transact sql

0 Answers  

---

---

What is difference between inner join and self join?

0 Answers  

---

what is sql profiler? : Sql dba

0 Answers  

---

Why do we use joins in sql?

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

What is the importance of sqlcode and sqlerrm?

0 Answers  

---

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

---

How do I quit sql?

0 Answers  

---