Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Statements: DML or DDL?

Statements: DML or DDL?

From: Benetnasch <benetnasch.spam.begone_at_blimey.co.uk>
Date: Wed, 11 Jul 2001 13:14:18 +0100
Message-ID: <vqX27.7973$B5.312997@monolith.news.easynet.net>

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 Thanks.

Also, will a S lock allow a RX lock on the same table at the same time?

Thanks again.

--
Benetnasch
Remove ".spam.begone"
Received on Wed Jul 11 2001 - 07:14:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US