Basic HTML version of Foils prepared 7 October 97

Foil 19 Major Schema Objects in Oracle - III -- Table

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox


Table - the basic unit of data storage in Oracle. The tables of a database hold all of the user-accessible data
Each table is defined with a table name and set of columns
Each column is given a column name, a datatype (CHAR, VARCHAR2, DATE or NUMBER), and a width
Once a table is created, valid rows of data can be inserted into it. The table's rows can then be queried, deleted, or updated



© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998