{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"Oracle SQL'de Mutating Trigger Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"Hvyy4MlXtF\"><a href=\"https:\/\/fatihsoysal.com\/blog\/oracle-sqlde-mutating-trigger-hatasi-cozumu\/\">Oracle SQL&#8217;de Mutating Trigger Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/oracle-sqlde-mutating-trigger-hatasi-cozumu\/embed\/#?secret=Hvyy4MlXtF\" width=\"600\" height=\"338\" title=\"&#8220;Oracle SQL&#8217;de Mutating Trigger Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"Hvyy4MlXtF\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!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);\n<\/script>\n","description":"Oracle veritabanlar\u0131nda s\u0131k kar\u015f\u0131la\u015f\u0131lan bir hata t\u00fcr\u00fc olan \"mutating trigger\" hatas\u0131, tetikleyicinin (trigger) ayn\u0131 anda hem okudu\u011fu hem de de\u011fi\u015ftirdi\u011fi tablo \u00fczerinde \u00e7al\u0131\u015fmas\u0131 sonucunda ortaya \u00e7\u0131kar. Bu durum, veritaban\u0131n\u0131n tutarl\u0131l\u0131\u011f\u0131n\u0131 ve g\u00fcvenilirli\u011fini tehlikeye atabilir. Bu makalede, bu hatan\u0131n nedenlerini, nas\u0131l te\u015fhis edilece\u011fini ve farkl\u0131 \u00e7\u00f6z\u00fcm y\u00f6ntemlerini detayl\u0131 olarak ele alaca\u011f\u0131z."}