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, search

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