Chapter 3. The Data Control and Data Manipulation Languages and the Data Dictionary

The main topics of this chapter are the Data Control Language (DCL), the Data Manipulation Language (DML), and Oracle’s data dictionary. DCL is used to grant the privileges needed to use Oracle. Without privileges, the user cannot even log on to an Oracle session. DML is used to maintain the data within the database. The language has commands for adding, modifying, and deleting records. The data dictionary is a series of tables/views that contain information about the database objects and how the objects are related to each other.

Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.