{"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":"SQL ve SPL'de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"cOZkHc538v\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\">SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/embed\/#?secret=cOZkHc538v\" width=\"600\" height=\"338\" title=\"&#8220;SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"cOZkHc538v\" 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":"Veritaban\u0131 y\u00f6netiminde, \u00f6zellikle hiyerar\u015fik verileri i\u015flemek i\u00e7in s\u0131kl\u0131kla \u00f6zyinelemeli referanslara ihtiya\u00e7 duyar\u0131z. Bu referanslar, bir tablodaki bir sat\u0131r\u0131n ayn\u0131 tablo i\u00e7indeki ba\u015fka bir sat\u0131ra i\u015faret etmesini sa\u011flar. \u00d6rne\u011fin, bir organizasyon \u015femas\u0131nda, her \u00e7al\u0131\u015fan bir y\u00f6neticinin alt\u0131ndad\u0131r ve bu y\u00f6neticinin de bir y\u00f6neticisi olabilir. Bu t\u00fcr verileri SQL ve SPL (Storage Procedure Language) gibi dillerle nas\u0131l etkili bir \u015fekilde i\u015fleyebilece\u011fimize bakal\u0131m."}