What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Procedures and Functions,Packages and Database Triggers.
A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve a specific problem or perform a set of related tasks.
Latest Answer : Procedure is a named PL/SQL block and a reusable database object which can accept multiple arguments, execute PL/SQL statements, do exception handling and return multiple results. Procedures are stored and executed in the database. ...
A Package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.
Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance
Latest Answer : pakage having more advantages1)Modularity2)Easily application dision ...
A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table.
Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.
What are the differences between Database Trigger and Integrity constraints ?
A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table. A trigger
Wht is the logic to find whether the entered input is a number or the character. How can we design this program using a procedure or the function
How does the conversion occur in MQ (Message Queue) to AQ (Advance Queue) through OMB (Oracle Message Broker)
