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).
CREATE TABLE [TABLE NAME] ( COLUMN DEFINITION );
CREATE TABLE TEST_TABLE
Related Code Snippets: