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

Which nosql database is best?

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

What are the different types of joins and explain them briefly.

3 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

What is sqlerrd?

0 Answers  

---

What are operators available in sql?

0 Answers  

---

What are the types of variables use in pl sql?

0 Answers  

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

define primary key & secondary key?

2 Answers  

---

Does sql profiler affect performance?

0 Answers  

---

How you will create Toad Function?

1 Answers  

---

How show all rows in sql?

0 Answers  

---