Pro Oracle Database 23ai Administration: Manage and Safeguard Your Organization’s Data

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024

M. Malcher, D. KuhnPro Oracle Database 23ai Administrationhttps://doi.org/10.1007/979-8-8688-1038-1_7

7. Tables and Constraints

Michelle Malcher¹   and Darl Kuhn²

(1)

Huntley, IL, USA

(2)

Morrison, CO, USA

 

The next logical step is to create objects in the database. Usually, the objects created for an application are tables, constraints, and indexes. A table is the basic storage container for data in a database. You create and modify the table structure via DDL statements, such as CREATE TABLE and ALTER TABLE. You access and manipulate table data via DML statements (INSERT, UPDATE, DELETE, MERGE, SELECT).

Tip

One important difference between DDL and DML statements ...