O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

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

18

Tables

In this chapter:

  • What is a table?

  • How do we create a table?

  • How do we change and destroy tables?

  • How are comments added to tables?

  • What is the recycle bin?

This chapter shows you how to do all sorts of stuff with tables. Creating and changing of tables includes defining and creating structure within tables and making changes to those structures. Subsequent chapters cover views and constraints. This chapter concentrates solely on tables.

18.1 What Is a Table?

Tables are used as structural definitions of data. The structure of a table defines what kind of data can be stored in the table. Rows of repeating data items are stored in tables in an Oracle schema. A schema is the Oracle user that owns the tables. A user and a schema are the ...

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