Glossary is usually defined as an alphabetical list of technical terms in some specialized field of knowledge. This knowledge base glossary provides a collection of knowledge base documents that define many technical terms. These terms are arranged alphabetically, but you can quickly jump to a specific term by selecting its first letter from the index of the knowledge base glossary below.

PL/SQL programs consist of blocks. Blocks take the general form: DECLARE -- Declaration block (optional) BEGIN -- Program proper EXCEPTION -- Exception-handling (optional) END /* Sample comment spanning multiple lines... */

In the context of a relational database table, a column is a set of data values of a particular simple type, one for each row of the table

A computer database is a structured collection of records or data that is stored in a computer system.

In the context of relational databases, a foreign key is a referential constraint between two tables.

PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural language supported by the PostgreSQL RDBMS.

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation`s proprietary procedural extension to the SQL database language. Some other SQL database management systems offer similar extensions to the SQL language. PL/SQL`s syntax strongly resembles that of Ada, and just like Ada compilers of the 80-s the PL/SQL runtime system uses Diana as intermediate representation.

The DECLARE section defines and (optionally) initialises variables. If not initialised specifically they default to NULL. DECLARE number1 NUMBER(2); number2 NUMBER(2) := 17; text VARCHAR2(12) := `Hello world`; text DATE := SYSDATE; -- current date and time BEGIN SELECT street_number INTO number1 FROM address WHERE name = `Smith`; END;

In relational database design, a unique key or primary key is a candidate key to uniquely identify each row in a table. A unique key or primary key comprises a single column or set of columns.

In the context of a relational database, a row—also called a record or tuple—represents a single, implicitly structured data item in a table.

SQL (pronounced /ɛskjuːˈɛl/; see below regarding the deprecation of another common pronunciation) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management