Practical Guide to using SQL in Oracle

Chapter 10

CREATE TABLE and SQLLOADER

In previous chapters we concentrated primarily on retrieving information from an existing database. This chapter revisits the creation and loading of tables and shows some of the constraints that we can place on table definitions. In particular, we will review the “simple” CREATE TABLE command and discuss the NOT NULL as well as PRIMARY KEY constraints. We will also discuss the UNIQUE and CHECK constraints and referential integrity. Finally, we will examine SQLLOADER and look at a couple of examples of it in use.

The “Simple” CREATE TABLE

You have seen “simple” CREATE TABLE statements in earlier chapters. To refresh your memory, consider the following example:

In this example, we create a table called Test1. ...