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

Term: HEAP

Definition:
The Oracle term HEAP refers to the default type of database table. One important characteristic of Heap organized tables are that the rows are dumped or inserted into the tables without following any particular order. Each row is identified by a unique ROWID, which will change if the row moves (even within the heap).

Since a HEAP table stores new rows in the first available location within the table, once rows are added and deleted in the table the row order tends to become randomized.

Other table types in Oracle are Index Organized Tables (IOT) and External Tables. External Tables are actually flat files, or text files with the data delimited by a specific character (often tabs, pipes, or commas).

Example Syntax:

CREATE TABLE [TABLE NAME] ( COLUMN DEFINITION );


Example Usage:

CREATE TABLE TEST_TABLE
(COL1 NUMBER,
COL2 VARCHAR2(100)
);

Table created.


Related Links:

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