PL-SQL Stored Objects Glossary

Back to root Glossary
These are special methods that create and initialize new instances of object types.
Data integrity
The completeness and accuracy of data, including the validity of relationships between rows in related tables.
A function is a set of PL/SQL code that is stored inside the database with a name. A function always returns a value. A function can use incoming parameters, but not outgoing parameters.
A marker imposed on a table or a row that prevents concurrent updates on the same table or row.
Lock level
The level to which a particular lock is imposed. Lock level can be either row (lock applies to one or more rows in a table), or table (lock applies to an entire table).
Lock mode
The source of the lock. Lock mode can be implicit (created automatically by the database) or explicit (imposed by program code.)
These are functions or procedures associated with an object type. They can be used to manipulate the data of an object instance or to perform operations on that instance.
Nested Tables:
These are collections of data elements, all of the same type, indexed by integers. They can be used to store and manipulate multi-valued attributes of an object type.
Object Privileges
These privileges allow a user to see objects
Object Types:
These are user-defined types that encapsulate data and methods to operate on that data. They are used to model complex real-world entities in the database.
A stored sub-program that combines PL/SQL procedures and functions into a single unit.
Package body
The portion of the package that defines to underlying procedures and functions. In addition, other functions and procedures that are private (for use only within the package) may be defined.
Package specification
The portion of the package that defines all public (callable) procedures and functions including their parameters.
A value passed to a PL/SQL stored object when it is executed. All types of PL/SQL stored objects except triggers can use parameters. Cursors also can use parameters. Parameters can be of nearly any datatype that can be defined within PL/SQL.
Permissions to either perform tasks or access data in the database
A grouping of privileges that is given a name
Stored function
A function that is stored as a named object in the database.
System privileges
These are permissions to do certain tasks in the database. For example, the capability to create a table is a system privilege.
Transaction control
A command used inside PL/SQL to tell Oracle when one transaction starts and ends. For example, the COMMIT command ends a transaction.
A stored sub-program that is similar to a procedure and is automatically executed by the database whenever a specified action occurs. The timing of a trigger specifies whether the trigger is executed before or after the action. The action of a trigger specifies activity in the database, such as a user updating one or more rows in a table. The scope of a trigger specifies whether the trigger fires once per row or once per transaction.
Varray (Variable-size Arrays):
These are collections of data elements, all of the same type, that have an upper limit to the number of elements they can store.