O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Creating Tables

Throughout this book, we've seen numerous ways to manipulate table data through the use of DML. But, up to this point, we've only manipulated existing tables. It's time to explore object creation with DDL—Data Definition Language—and how it can be used to create database tables that support business rules.

In this chapter, we shall:

  • Discuss Data Definition Language (DDL) and its purpose
  • Understand Oracle's schema-based approach
  • Examine the structure of tables and datatypes
  • Describe the CREATETABLE syntax
  • Use CREATETABLEAS..SELECT to copy tables
  • Examine the purpose of constraints
  • Understand and use different types of constraints

Introducing Data Definition Language

In Chapter 4, Data Manipulation with DML we established a distinction ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required