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:

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