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 are the ways on commenting in a pl/sql code?

0 Answers  

---

Can %notfound return null after a fetch?

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

What is sql in oracle?

0 Answers  

---

Can we use threading in pl/sql?

0 Answers  

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

Explain what is sql?

0 Answers  

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

What is sqlite used for?

0 Answers  

---

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

What is meaning of <> in sql?

0 Answers  

---