PL/SQL, how would you trap and report on errors (Oracle specific)? Define a primary key constraint on a table? What

PL/SQL, how would you trap and report on errors (Oracle specific)? Define a primary key constraint on a table? What

Question:

PL/SQL, how would you trap and report on errors (Oracle specific)?Define a primary key constraint on a table?What is a database trigger?How will you use the Coalesce function and the nvl functions (Oracle specific)?

Expert Answer:

Answer rating: 100% (QA)

In PL SQL you can trap and report errors using exception handling constructs like BEGIN EXCEPTION END Oracle provides a set of predefined exceptions t
View the full answer