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. ...