OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » DDL and DML

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DDL and DML [message #608917]

Wed, 26 February 2014 18:48

deepak439
Messages: 1
Registered: February 2014
Location: hyderabad

Junior Member

all ddl commands are autocommit and dml commands are stored in tempory memory it means they are not saved if we shutdown our laptop without COMMIT command...but Insert command is automatically inserting the values and saving without commit..can you explain me in breif...my mail id: deepak.nallapati@gmail.com

Report message to a moderator

Re: DDL and DML [message #608918 is a reply to message #608917]

Wed, 26 February 2014 18:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> Insert command is automatically inserting the values and saving without commit..
I challenge you to post a whole session that shows above is true.
If INSERT data without any COMMIT occur, then no other session can "see" any of the new rows.
Only after COMMIT are the new rows permanent & can be accessed by other sessions.
Statement above is 100% & totally WRONG!

Report message to a moderator

Re: DDL and DML [message #608924 is a reply to message #608917]

Thu, 27 February 2014 00:46

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I bet you use a tool with autocommit set to on.
Note that this, as far as I remember, is the default behaviour of JDBC driver.

Report message to a moderator

Previous Topic:	Need invalid records
Next Topic:	Need help to build xml tag in oracle sql queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:43:02 CDT 2024