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

From Wikibooks, open books for an open world
< Oracle and DB2, Comparison and Compatibility‎ | Storage Model‎ | Tables
Jump to navigation Jump to search


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
Oracle Table in a Tablespace.jpg