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

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

What is the trigger in sql?

0 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

---

What is scalar function in sql?

0 Answers  

---

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

How many aggregate functions are available there in sql?

0 Answers  

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

---

What are the parts of a sql statement?

0 Answers  

---

What are different methods to trace the pl/sql code?

0 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---