© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024
M. Malcher, D. KuhnPro Oracle Database 23c Administrationhttps://doi.org/10.1007/978-1-4842-9899-2_7

7. Tables and Constraints

Michelle Malcher1   and Darl Kuhn2
(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 ...

Get Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization’s Data 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.