1.0Istra Techhttps://www.istratech.hr/en/Istratech Adminhttps://www.istratech.hr/en/author/istratech_admin/When isn't an Oracle command serialisable? – Istra Techrich600338<blockquote class="wp-embedded-content" data-secret="8Muizti9Zw"><a href="https://www.istratech.hr/en/when-isnt-an-oracle-command-serialisable/">When isn’t an Oracle command serialisable?</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.istratech.hr/en/when-isnt-an-oracle-command-serialisable/embed/#?secret=8Muizti9Zw" width="600" height="338" title="“When isn’t an Oracle command serialisable?” — Istra Tech" data-secret="8Muizti9Zw" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
//# sourceURL=https://www.istratech.hr/wp-includes/js/wp-embed.min.js
</script>
ABSTRACT Oracle transaction is NOT serializable by default, because the default is ISOLATION LEVEL READ COMMITED. If we want the transaction to be serializable, we must explicitly state SET TRANSACTION ISOLATION LEVEL SERIALIZABLE. Unlike the transaction, Oracle SELECT and DML statements are by default serializable (statement-level read consistency). This means that the statement does not […]