Overview of Tables (154)

Tables are the basic unit of data storage in an Oracle database. Data is stored in rows
and columns. You define a table with a table name (such as employees) and set of
columns. You give each column a column name (such as employee_id, last_name,
and job_id), a datatype (such as VARCHAR2, DATE, or NUMBER), and a width. The
width can be predetermined by the datatype, as in DATE. If columns are of the NUMBER
datatype, define precision and scale instead of width. A row is a collection of column
information corresponding to a single record.
You can specify rules for each column of a table. These rules are called integrity
constraints. One example is a NOT NULL integrity constraint. This constraint forces the
column to contain a value in every row.
You can also specify table columns for which data is encrypted before being stored in
the datafile. Encryption prevents users from circumventing database access control
mechanisms by looking inside datafiles directly with operating system tools.
After you create a table, insert rows of data using SQL statements. Table data can then
be queried, deleted, or updated using SQL.

表
1. 表是 Oracle 資料庫中最基本的資料儲存結構 . 資料在表中以行和列的形式儲存.
2. 定義表時指定表名 , 列名 , 資料型別
3. 使用者可以為表列設定規則 , 稱為完整性約束.

[@more@]