Murach's Oracle SQL and PL/SQL
How to create tables, indexes, and sequences

This chapter shows how to implement a database design by using the SQL data definition language (DDL) statements to create and modify tables, indexes, and sequences.
Chapter 10 How to create tables, indexes, and sequences
How to work with tables 312
How to create a table 312
How to code a primary key constraint 314
How to code a foreign key constraint 316
How to code a check constraint 318
How to alter the columns of a table 320
How to alter the constraints of a table 322
How to rename, truncate, and drop a table 324
How to work with indexes 326
How to create an index 326
How to drop an index 326
How to work with sequences 328
How to create a sequence 328
How to use a sequence 328
How to alter a sequence 330
How to drop a sequence 330
The script used to create the AP schema 332
An introduction to scripts 332
How the DDL statements work 332
How to use SQL Developer 338
How to work with the columns of a table 338
How to work with data of a table 338
How to work with the constraints of a table 340
How to work with indexes 342
How to work with sequences 344


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.