|
|
A table is a list of values. All of the values can be
of the same type. If the values are of different types, they should be
organized in various categories. Each category is then called a column.
Here is an example of a table:
|
| Name |
Age |
Gender |
Relationship |
| Judie |
18 |
Female |
Sister |
| Ernest |
24 |
Male |
Cousin |
| Bill |
52 |
Unknown |
Uncle |
| David |
36 |
Male |
Brother |
| Hermine |
12 |
Unknown |
Niece |
You can create your own table or use a table created by
someone else.
|
 Practical
Learning: Starting a Database
|
|
- To launch Oracle, click Start -> (All) Programs -> Oracle - OraDb11g_home1 ->
Application Development -> SQL Plus
- Enter the username and press Enter
- Enter the password and press Enter
A table organizes its information in categories
called columns and horizontal arrangements called records or rows. A column holds
a category of data that is common to all records. There are two primary
requirements you must fulfill to get a table:
- You must create a table
- The new table must have at least one column
This means that you cannot create a table without
defining at least one column.
To complete the creation of a table, you must name it. To name a table, follow the same rules we reviewed for variables.
To create a table, you start with the
following statement:
CREATE TABLE TableName;
The CREATE TABLE expression is
required. The TableName factor specifies the
name of the new table. After specifying the name of the table, you must
create at least one column.
Table maintenance consists of reviewing or changing
its aspects. This includes reviewing the list of tables of a database,
renaming a table, or deleting it.
