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

how to drop an existing table in mysql? : Sql dba

1 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1 Answers   CTS,

---

What are local and global variables and their differences?

1 Answers  

---

Can we use two order by clause in query?

1 Answers  

---

what is the difference between truncate and drop statements? : Sql dba

1 Answers  

---

Do prepared statements prevent sql injection?

1 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

Is it important to partition hard disk?

1 Answers  

---

what is auto increment? : Sql dba

1 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1 Answers  

---

what are the differences between binary and varbinary? : Sql dba

1 Answers  

---

What is not null in sql?

1 Answers  

---