Wikibooks

Oracle and DB2, Comparison and Compatibility/Storage Model/Tables/Oracle

< Oracle and DB2, Comparison and Compatibility | Storage Model | Tables
This page may need to be reviewed for quality.

Oracle

edit

Tables are logical structures that the end user works with, they contain columns and rows. Columns describe attributes of rows in the table, and each column has a name (i.e. Social_Security_Number), a data type and width, precision or scale. When tables are created, Oracle allocates a segment in the table space for the table. Data is added, removed, selected and changed by database row, and this is usually done through SQL

Oracle Tables in a Tablespace
 
Retrieved from "https://en.wikibooks.org/wiki/Oracle_and_DB2,_Comparison_and_Compatibility/Storage_Model/Tables/Oracle"