Jump to content

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

Add links
From Wikibooks, open books for an open world

Oracle

[edit | edit source]

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"