Chapter 10


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.


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

Get Practical Guide to using SQL in Oracle now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.