Thanks.
--
Benetnasch
Remove ".spam.begone"
Thomas Kyte <tkyte_at_us.oracle.com> wrote in message
news:9ihiq202roi_at_drn.newsguy.com...
> In article <vqX27.7973$B5.312997_at_monolith.news.easynet.net>, "Benetnasch"
> says...
> >
> >Could anyone please tell me whether the following
> >statements are DML or DDL:
> >
> >CREATE INDEX (DDL, I think)
> >ALTER TABLE (DDL, I think)
> >SET CONSTRAINT
> >SET ROLE
> >SET TRANSACTION
> >
>
> see
>
http://technet.oracle.com/doc/oracle8i_816/server.816/a76989/introsq2.htm#99
9871
>
> there are:
>
> Data Definition Language (DDL) Statements
> Data Manipulation Language (DML) Statements
> Transaction Control Statements
> Session Control Statements
> System Control Statements
>
> the create/alert = ddl. the set = session control
>
>
>
> >Thanks.
> >
> >Also, will a S lock allow a RX lock on the same
> >table at the same time?
> >
>
> See the server concepts, chapter 24, "how oracle locks data/types of
locks",
> there is a table there that shows what is permitted when.
>
> A S (share) lock on a table will not permit a RX (row exclusive)
>
>
> >Thanks again.
> >
> >--
> >Benetnasch
> >Remove ".spam.begone"
> >
> >
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Wed Jul 11 2001 - 09:18:16 CDT
