| A | B |
|---|
| Object Directory | BFILES are stored here |
| BFILE | Does not have normal system privileges granted on it. |
| CLOB | LOB stored inside of database |
| Mutating Table | Currently being modified by DML |
| DBMS_OUTPUT | a package that sends text messages from any PLSQL block into a private memory area. |
| Object Privilege | Permits the use of a specific database object |
| Remove a procedure | DROP PROCEDURE raise_salary; |
| DICT | Lists all the names in data dictionary tables |
| USER_* TABLE conatins | Information about objects you own. |
| ALL_* TABLE contains | Information about objects which you have privileges to use. |
| DATA DICTIONARY | automatically registered when they are created |
| Anonymous Block | unnamed |
| EXCEPTION | occurs when an error is discovered during execution |
| IMPLICIT CURSOR | AUTOMATICALLY CREATED |
| WHILE LOOP | uses a controlling condition |
| DATATYPE attribute | %TYPE |
| NCLOB | LOB for national character values |
| PARAMETERS | values passed to a program |
| VARIABLES | Storing and manipulating data |
| EXECUTABLE | mandatory section of block |
| BLOCK | basic unit of PL/SQL program |
