This forum is currently locked. You can't register or post questions at this time. (read more)

create and grant command need to be committed?

All posts relating to Oracle database administration.

Moderator: Tim...

dba_newuser
Member
Posts: 2
Joined: Mon Nov 11, 2013 1:30 am

create and grant command need to be committed?

Postby dba_newuser » Mon Nov 11, 2013 1:38 am

Hi Tim,
I am a new studying oracle database.

Create and grant command do not commit ? right. Thanks.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: create and grant command need to be committed?

Postby Tim... » Mon Nov 11, 2013 10:04 am

Hi.

That's correct. Both CREATE and GRANT are known as DDL (Data Definition Language). In Oracle, all DDL has an implicit COMMIT, so you don't need to add one. Remember also, the implicit commit will commit all DML changes in the session that came before it.

DML = Data Manipulation Language. That's INSERT, UPDATE, DELETE, MERGE. These all need an explicit COMMIT, unless followed by DDL. :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

dba_newuser
Member
Posts: 2
Joined: Mon Nov 11, 2013 1:30 am

Re: create and grant command need to be committed?

Postby dba_newuser » Tue Nov 12, 2013 1:04 am

Hi Tim,

Understood. Thx.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: create and grant command need to be committed?

Postby Tim... » Tue Nov 12, 2013 10:13 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 5 guests

cron