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.
- HEAP refers to no specific or defined ordering of records.
- INDEX refers to Index organized tables, where records are stored in an Index on the primary key column in the table
- EXTERNAL specifies that table source is outside the server and treats the source as read only
ORGANIZATION [HEAP | INDEX | EXTERNAL]
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,