Quick Search:
 
 The Oracle PL/SQL ORGANIZATION Keyword      [Return To Index] Jump to:  

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 |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org