Skip to content

Instantly share code, notes, and snippets.

@fabsenet

fabsenet/Oracle Transaction.sql

Last active August 29, 2015 13:57
Show Gist options
  • Save fabsenet/9891832 to your computer and use it in GitHub Desktop.
Save fabsenet/9891832 to your computer and use it in GitHub Desktop.
Download ZIP
Transaction Sample: SQL Server vs. Oracle
Raw
Oracle Transaction.sql
--Oracle
set transaction name 'mytransaction';
update mytable set somecolumn = 'some value' where id = 22;
commit;
Raw
SQL Server Transaction.sql
--SQL SERVER
begin tran
update mytable set somecolumn = 'some value' where id = 22
commit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment