Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle MODE Keyword      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: MODE

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:

  1. INSERTS can be done in SERIAL or PARALLEL mode

  2. From Oracle 11g version, an INDEX can be created in VISIBLE or INVISIBLE mode

  3. From Oracle 11g version, a table can be created in READ-ONLY mode or READ-WRITE mode

  4. A DML trigger can be created in ENABLED or DISABLED mode

  5. A table can be locked in SHARE or EXCLUSIVE mode

  6. Parameters can be passed in IN, OUT and IN OUT modes


Related Code Snippets:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 261 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?