Definition:
In Oracle PL/SQL, MODE is a general term used to describe permissible values allowed for a clause in a statement which performs some action. Each mode carries its own features and effects. For example, a database can operate in NOARCHIVELOG mode (media recovery disabled) or ARCHIVELOG mode (media recovery enabled). In short, a MODE is a defined method of operation.
These are a few examples of modes available in Oracle along with their context usage:
- INSERTS can be done in SERIAL or PARALLEL mode
- From Oracle 11g version, an INDEX can be created in VISIBLE or INVISIBLE mode
- From Oracle 11g version, a table can be created in READ-ONLY mode or READ-WRITE mode
- A DML trigger can be created in ENABLED or DISABLED mode
- A table can be locked in SHARE or EXCLUSIVE mode
- Parameters can be passed in IN, OUT and IN OUT modes
Related Code Snippets: