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

Get Oracle SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.