What is Raise_application_error in oracle?

What is Raise_application_error in oracle?

Raise_application_error allows users to create custom error messages.

Syntax :
Raise_application_error (error_number error_messages);

Here, error_number is between -20000 to -20999 because remaining numbers are for Oracle. Message can be varchar(2000)
They are most commonly used to handle unwanted and unmanageable exceptions.
Difference between a View and Materialized View in oracle.
View is created joining a single or multiple tables. It is an abstract of the data distributed in different tables.....
What are the kinds of roles in oracle?
What are the kinds of roles in oracle? - Following are the kinds of roles available in oracle: ....
Define primary key and foreign key
Define primary key and foreign key - A column or combination of columns that identify a row of data in a table is Primary Key. A key in a table that identifies records in other table in called a foreign key....
Post your comment

Related Content

Follow us

▲