How to declare a variable with float (2 decimal places) in table creation in Oracle?
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 does not apply to data loaded before the definition of the...
A function returns a value to the caller where as a procedure does not.
Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into...
Procedures and functions,packages and database triggers.
A package is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.
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.