Purpose. Use the CREATE TABLE statement to create one of the following types of tables: A relational table, which is the basic structure to hold user data.

Purpose. Use the CREATE TABLESPACE statement to create a tablespace, which is an allocation of space in the database that can contain schema objects.

Purpose. Use the CREATE VIEW statement to define a view, which is a logical table based on one or more tables or views. A view contains no data itself.

Purpose. Use the CREATE INDEX statement to create an index on: One or more columns of a table, a partitioned table, an index-organized table, or a cluster.

Purpose. Use the ALTER TABLE statement to alter the definition of a nonpartitioned table, a partitioned table, a table partition, or a table subpartition.

Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, operator, procedure, stored function, package, ...

The Built-In Data Type Summary table lists the built-in data types available. Oracle Database uses a code to identify the data type internally. This is the ...

Purpose. Use a SELECT statement or subquery to retrieve data from one or more tables, object tables, views, object views, materialized views, analytic views ...

Use the CREATE TYPE BODY to define or implement the member methods defined in the object type specification. You create object types with the CREATE TYPE and ...

Purpose. Use the INSERT statement to add rows to a table, the base table of a view, a partition of a partitioned table or a subpartition of a ...