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

Term: ORGANIZATION

Definition:
In Oracle PL/SQL, the ORGANIZATION clause is used in the CREATE_TABLE command to specify the orientation of record storage. It can be HEAP, INDEX or EXTERNAL. Indirectly, these types refer to the type of the table. There are three possible values for ORGANIZATION clause.

  1. HEAP refers to no specific or defined ordering of records.
  2. INDEX refers to Index organized tables, where records are stored in an Index on the primary key column in the table
  3. EXTERNAL specifies that table source is outside the server and treats the source as read only

Example Syntax:

CREATE TABLE
(COL1...
COL2...)
ORGANIZATION [HEAP | INDEX | EXTERNAL]


Example Usage:

The SQL below creates a table named "T_PSOUG" whose organization has been set as INDEX. The index has been based on the primary key column i.e. ID.

CREATE TABLE T_PSOUG
(ID NUMBER PRIMARY KEY,
PROJECT VARCHAR2(100),
NAME VARCHAR2(100),
START_DT DATE)
ORGANIZATION INDEX



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