|
 |
|
Oracle Create Table Tips
Oracle Tips by Burleson Consulting |
Oracle Create Table
Before tables can be used, they have to be created and
this is generally the job of the DBA. Creating tables is done with the create
table command. The Oracle create table command does the following:
-
Oracle create table syntax defines the table name
-
Oracle create table syntax defines the columns in the table and the datatypes of
those columns
-
Oracle create table syntax defines what tablespace the table resides in
(optional)
-
Oracle create table syntax defines other characteristics of the table (optional)
Let’s look at the create table command in action:
Connect
scott/tiger
CREATE
TABLE books
( book_id
NUMBER PRIMARY KEY,
book_name VARCHAR2(30),
author_name VARCHAR2(40),
book_isbn VARCHAR2(20) )
TABLESPACE users;
In this example, we did a create table for a table called BOOKS which
has 4 columns. The first column is BOOK_ID which is a NUMBER datatype. This
means we will be storing numbers in this column. Did you notice on the line
where we define the column BOOK_ID, that we included the word primary key?
This is known as an in-line constraint because we are
defining the constraint on the same line as the column associated with the
constraint. In this case the keyword primary key means we are defining a primary
key constraint on the BOOKS table called PK_BOOKS.
Also see:
-
Using Oracle
create table as select
-
Oracle create
index
|
