Re: PL/SQL - does it do all sql statements???????

From: Tim Smith <tssmith_at_netcom.com>
Date: Fri, 20 Aug 1993 19:26:17 GMT
Message-ID: <tssmithCC2onu.79L_at_netcom.com>


In article <1993Aug20.163242.29888_at_relay.nswc.navy.mil> rlarson_at_nswc-wo.nswc.navy.mil (Ruth Larson) writes:
>
>From Oracle V6 DBA Manual:
>
>"Data Control Statements (DCL) DCL statements are used to control two types
>of access:
> o Access to the database (using, for example, GRANT CONNECT)
> o Access to the database data (using, for example, GRANT
> SELECT or REVOKE DELETE).
>DCL statements allow one user to let other users see, change, and use data
>in his tables, and even to pass their privileges on to other users (GRANT
>SELECT ... WITH GRANT OPTION). Data control statements also include the
>AUDIT statements.
> DCL and DDL statements are often categorized together. ..."
>
>DCL = data control language

The term "data control language" (DCL) is no longer used with Oracle7. Most of the older DCL commands are now DDL commands. There are six categories of command (defined in the SQL LRM, p 4-2):

DDL
DML
Transaction Control
Session Control
System Control
Embedded SQL

--Tim (tssmith_at_netcom.com)   Received on Fri Aug 20 1993 - 21:26:17 CEST

Original text of this message