e-Commerce Applications Using Oracle8i and Java from Scratch

SQL Commands

SQL commands can be broken down into three categories based on the type of database functions they perform:

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Control Language (DCL)

A fourth SQL subset called Embedded SQL (EMB) is also supported by Oracle. We will discuss the most commonly used commands in this chapter. For a complete and detailed description of the various SQL commands, please refer to the SQL Language Reference manual that came with your Oracle Server software.

Data Definition Language

Data Definition Language refers to the commands that are used for creating and manipulating the schema or structure of a database. Table 3.1 shows the commonly used DDL commands.

Table 3.1. Commonly Used DDL Commands ...