Re: DML & DDL Confusion

DML is Data Manipulation Language, DDL is Data Definition Language. Thus, DML is SELECT, INSERT, UPDATE, DELETE. DDL is CREATE, ALTER, MODIFY.

Note : GRANT is *not* DDL. It is DCL -- Data Control Language.

Quoting from the 8.1.7 SQLPlus User's Guide and Reference - Glossary : Data Control Language (DCL)
The category of SQL statements that control access to the data and to the database. Examples are the GRANT and REVOKE statements. Occasionally DCL statements are grouped with DML statements.

Data Definition Language (DDL)
The category of SQL statements that define or delete database objects such as tables or views. Examples are the CREATE, ALTER, and DROP statements.

Data Manipulation Language (DML)
The category of SQL statements that query and update the database data. Common DML statements are SELECT, INSERT, UPDATE, and DELETE. Occasionally DCL statements are grouped with DML statements.

Hemant K Chitale

"Sted Alana" <Sted_Alana_at_hotmail.com> wrote in message news:3cd64793$1_1_at_news.iprimus.com.au...
> Can someone please explain the difference between DML and DDL in simple
> terms - its a little confusing.
>
> Any help appreciated.
>
>
> --
> N e w s N e t C u s t o m e r
> E - m a i l : sted.alana_at_hotmail.com
>
>
>
>
>
>
Received on Mon May 06 2002 - 08:54:40 CDT