• Fabian Wetzel
• 2014-03-31
  
• 1 min. read

I know how to do transactions in SQL Server. It is really easy, at least for me. In ORACLE, the keywords are slightly different and you have to use semicolons at the end of each statement. You also have to name your transaction but an empty string will do just fine.

Compare this for yourself:

1
2
3
4

--Oracle
set transaction name 'mytransaction';
update mytable set somecolumn = 'some value' where id = 22;
commit;

1
2
3
4

--SQL Server
begin tran
update mytable set somecolumn = 'some value' where id = 22
commit