Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications,
Latest Answer : A database trigger is a named pl/sql block associated with a table and fires automatically when an event occurs or something happens. Data auditing , Implementing complex business rules, security are main uses of database triggers. ...
Raise_application_error is a procedure of package DBMS_STANDARD which allows to issue an user_defined error messages from stored sub-program or database
Latest Answer : You can use this procedure to issue user-defined error messages from stored subprograms.You can report errors to your application and avoid returning unhandled exceptions.Syntax: raise_application_error (error_number,message[, {TRUE | FALSE}]); ...
In the standard package. Procedures, Functions & Packages ;
Latest Answer : Predefined exceptions are globally declared in standard package ...
A stored procedure is a sequence of statements that perform specific function.
Latest Answer : A procedure is a named PL/SQL block that can accept parameters (sometimes referred to as arguments), and be invoked. Generally speaking, you use a procedure to perform an action. A procedure has a header, a declaration section, an executable section, ...
What are advantages fo Stored Procedures / Extensibility,Modularity, Reusability, Maintainability and one time compilation.
a. Stored procedure or anonymous block b. an application program such a PRC *C, PRO* COBOL c. SQL *PLUS
Latest Answer : a. PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTION NAME (arguments); b. BEGIN PACKAGE NAME.PROCEDURE ...
Name the tables where characteristics of Package, procedure and functions are stored ?
User_objects, User_Source and User_error.
What is difference b/w stored procedures and application procedures,stored function and application function..
In function and procedure the parameter pass is "call by value" or "call by reference"?
