<<Back to DB Administration Main Page
Tables in Oracle Database
What is a Table?
A table is the basic unit of data organization in an Oracle database.
Types of tables in Oracle
There are 2 types of tables in oracle
1> Relational Tables
2> Object Tables
What is Relational Tables?
Relational tables have simple columns and are the most common table type. Relational Tables can be created as
Heap Organized Table
Index Organized Table
External Table
What is Heap Organized Table?
A heap-organized table does not store rows in any particular orderWhat is Index Organized Table?
An index-organized table orders rows according to the primary key values.
What is External Table?
An external table is a read-only table whose metadata is stored in the database
but whose data is stored outside the database.
but whose data is stored outside the database.
NOTE:- A table is either a temporary table (create with create temp table clause) or a permanent Table
Comments
Post a Comment