Database Reference
In-Depth Information
18
Tables
In this chapter:
What is a table?
How do we create a table?
How do we change and destroy tables?
How are comments added to tables?
What is the recycle bin?
This chapter shows you how to do all sorts of stuff with tables. Creating
and changing of tables includes defining and creating structure within
tables and making changes to those structures. Subsequent chapters cover
views and constraints. This chapter concentrates solely on tables.
18.1
What Is a Table?
Tables are used as structural definitions of data. The structure of a table
defines what kind of data can be stored in the table. Rows of repeating data
items are stored in tables in an Oracle schema. A schema is the Oracle user
that owns the tables. A user and a schema are the same thing as far as Oracle
Database is concerned. An Oracle relational database can contain many
Oracle schemas
A schema in Oracle is the equivalent of a single database in
other relational databases such as Sybase or Ingres.
.
18.1.1
Types of Tables
Oracle Database 10
supports many different types of tables. The easiest
method of explanation is to list the different available table types as follows:
g
