Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Chapter 7. SQL

Structured Query Language (SQL) has evolved over the years into the standard language for operations on relational databases. While each database vendor has implemented its own version of SQL, Oracle has remained fairly compliant with the ANSI SQL standard, although the company has certainly added its share of extensions and enhancements with each new release of the database.

SQL statements fall into two categories: Data Definition Language (DDL) and Data Manipulation Language (DML). You invoke DDL statements when you need to manipulate the structure of your Oracle database. You can use DDL statements to define, modify, and remove every type of object that can exist in an Oracle database. Many of the DDL statements require special database privileges and are normally executed by the DBA.

Data Manipulation Language (DML) statements, on the other hand, access and manipulate data stored in the Oracle database. You can use DML statements to insert, update, delete, and read data, as well as to control how Oracle operates when accessing data in the database.

This chapter provides a quick reference to the two types of SQL statements and their syntax. The common keywords and identifiers, summarized in the first section, apply to both types of statements.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page