Home » SQL & PL/SQL » SQL & PL/SQL » commit. Please help
commit. Please help [message #433211] Mon, 30 November 2009 13:30 Go to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Good afternoon.

I wonder if I need to commit after create table? Thanks.

LN
Re: commit. Please help [message #433213 is a reply to message #433211] Mon, 30 November 2009 13:32 Go to previous messageGo to next message
joy_division
Messages: 4616
Registered: February 2005
Location: East Coast USA
Senior Member
no.
Re: commit. Please help [message #433214 is a reply to message #433211] Mon, 30 November 2009 13:33 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Thanks much.
Re: commit. Please help [message #433215 is a reply to message #433211] Mon, 30 November 2009 13:37 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have not to commit after a DDL but you have to know that a DDL commits your previous work.

Regards
Michel
Re: commit. Please help [message #433216 is a reply to message #433211] Mon, 30 November 2009 13:42 Go to previous messageGo to next message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
That means DDL commit by defaut? Thanks
Re: commit. Please help [message #433226 is a reply to message #433216] Mon, 30 November 2009 14:35 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it commits at least 2 times, once before starting and once after completing.

Regards
Michel
Re: commit. Please help [message #433229 is a reply to message #433216] Mon, 30 November 2009 15:30 Go to previous messageGo to next message
joy_division
Messages: 4616
Registered: February 2005
Location: East Coast USA
Senior Member
lamnguyen14 wrote on Mon, 30 November 2009 14:42
That means DDL commit by defaut? Thanks


Not sure if you're getting the meaning of Michel's post. Yes, your DDL will autocommit your statement, but it will commit all previous work too.
Re: commit. Please help [message #433308 is a reply to message #433211] Tue, 01 December 2009 06:58 Go to previous message
lamnguyen14
Messages: 119
Registered: March 2007
Location: Virginia
Senior Member
Thanks much to all of you.
Previous Topic: strange problem
Next Topic: isDigit () method in PL/SQL
Goto Forum:
  


Current Time: Mon Sep 26 16:17:45 CDT 2016

Total time taken to generate the page: 0.07319 seconds