10.1. Creating Tables
The table is the most basic and most important object you will create in a database. Essentially, you could do without every other database object in a database except for tables. Without tables, you cannot store anything in a database.
You can create tables with the CREATE TABLE statement or "on the fly" with a method known as Create Table As Select, or CTAS.
Once you know that you need to create a table, you must decide what kind of table you want. In this section, we'll cover the most common types of tables:
Relational tables
Tables created directly from the result of a query
Tables whose data resides outside the database
Tables with a definition that is available to all sessions but whose data is local to the session that ...
Get Oracle Database Foundations 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.
