Quick Search:
 
 Oracle HEAP Tables      [Return To Index] Jump to:  

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