{"id":15596,"date":"2025-03-19T06:15:14","date_gmt":"2025-03-19T03:15:14","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/"},"modified":"2025-03-19T06:15:14","modified_gmt":"2025-03-19T03:15:14","slug":"sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/","title":{"rendered":"SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi"},"content":{"rendered":"<p><body><\/p>\n<p>SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi<\/p>\n<p>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.<\/p>\n<p>\u00d6ncelikle, SQL&#8217;de \u00f6zyinelemeli sorgulamalar\u0131n nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131na de\u011finelim.  <b>COMMON TABLE EXPRESSION (CTE)<\/b> kullanarak, \u00f6zyinelemeli bir sorgu tan\u0131mlayabilir ve hiyerar\u015fiyi ad\u0131m ad\u0131m hesaplayabiliriz.  A\u015fa\u011f\u0131daki \u00f6rnekte, bir employees tablosunun hiyerar\u015fisini g\u00f6steren bir CTE kullan\u0131yoruz:<\/p>\n<pre><code class=\"language-sql\">\nWITH RECURSIVE EmployeeHierarchy AS (\n    SELECT employee_id, manager_id, employee_name, 1 AS level\n    FROM employees\n    WHERE manager_id IS NULL  -- Ba\u015flang\u0131\u00e7 noktas\u0131: en \u00fcst d\u00fczey y\u00f6netici\n    UNION ALL\n    SELECT e.employee_id, e.manager_id, e.employee_name, eh.level + 1\n    FROM employees e\n    INNER JOIN EmployeeHierarchy eh ON e.manager_id = eh.employee_id\n)\nSELECT * FROM EmployeeHierarchy;\n<\/code><\/pre>\n<p>Bu sorgu, en \u00fcst d\u00fczey y\u00f6neticiden ba\u015flayarak alt\u0131ndaki t\u00fcm \u00e7al\u0131\u015fanlar\u0131 seviyelerine g\u00f6re s\u0131ralar.  <b>UNION ALL<\/b> operat\u00f6r\u00fc, her seviyeyi bir \u00f6nceki seviyenin \u00e7\u0131kt\u0131s\u0131na ekleyerek hiyerar\u015fiyi olu\u015fturur.  <b>WHERE manager_id IS NULL<\/b> ko\u015fulu ise, en \u00fcst d\u00fczey y\u00f6neticileri belirler.<\/p>\n<p>Ancak, b\u00fcy\u00fck veriler i\u00e7in SQL performans\u0131 d\u00fc\u015febilir. Bu noktada, SPL gibi bir dil daha verimli bir \u00e7\u00f6z\u00fcm sunabilir.  SPL, prosed\u00fcrel bir dil oldu\u011fu i\u00e7in, daha karma\u015f\u0131k mant\u0131\u011f\u0131 daha kolay ve etkili bir \u015fekilde uygulayabiliriz.  A\u015fa\u011f\u0131daki \u00f6rnekte, benzer bir hiyerar\u015fiyi SPL ile hesapl\u0131yoruz (\u00f6rnek bir SPL dili kullan\u0131lm\u0131\u015ft\u0131r, syntax farkl\u0131l\u0131k g\u00f6sterebilir):<\/p>\n<pre><code class=\"language-sql\">\nCREATE PROCEDURE GetEmployeeHierarchy()\nBEGIN\n  DECLARE done INT DEFAULT FALSE;\n  DECLARE current_employee_id INT;\n  DECLARE current_manager_id INT;\n  DECLARE current_employee_name VARCHAR(255);\n  DECLARE level INT DEFAULT 1;\n\n  DECLARE cur CURSOR FOR SELECT employee_id, manager_id, employee_name FROM employees WHERE manager_id IS NULL;\n  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;\n\n  OPEN cur;\n  read_loop: LOOP\n    FETCH cur INTO current_employee_id, current_manager_id, current_employee_name;\n    IF done THEN\n      LEAVE read_loop;\n    END IF;\n    -- Burada \u00f6zyinelemeli bir fonksiyon \u00e7a\u011fr\u0131s\u0131 ile alt \u00e7al\u0131\u015fanlar\u0131 i\u015fleyece\u011fiz.\n    -- ...\n  END LOOP;\n  CLOSE cur;\nEND;\n<\/code><\/pre>\n<p>SPL&#8217;deki bu yakla\u015f\u0131m, SQL&#8217;deki CTE&#8217;ye g\u00f6re daha fazla kontrol ve \u00f6zelle\u015ftirme imkan\u0131 sa\u011flar. \u00d6rne\u011fin, performans\u0131 iyile\u015ftirmek i\u00e7in \u00f6zel algoritmalar veya indeksleme teknikleri kullanabiliriz.  Ancak, SPL&#8217;nin kod yaz\u0131m\u0131 ve bak\u0131m\u0131 daha karma\u015f\u0131k olabilir.<\/p>\n<p>Sonu\u00e7 olarak, hem SQL hem de SPL \u00f6zyinelemeli referanslar\u0131 i\u015flemek i\u00e7in kullan\u0131labilir.  Se\u00e7im, veri k\u00fcmesinin b\u00fcy\u00fckl\u00fc\u011f\u00fc, performans gereksinimleri ve geli\u015ftiricinin uzmanl\u0131\u011f\u0131na ba\u011fl\u0131 olarak yap\u0131lmal\u0131d\u0131r.  Daha k\u00fc\u00e7\u00fck veriler i\u00e7in SQL&#8217;deki CTE&#8217;ler olduk\u00e7a pratiktir. Ancak, b\u00fcy\u00fck ve karma\u015f\u0131k hiyerar\u015filer i\u00e7in SPL daha verimli bir \u00e7\u00f6z\u00fcm olabilir.  <a href=\"https:\/\/fatihsoysal.com\">Benim web sitemde<\/a>  bu konuyla ilgili daha fazla bilgi bulabilirsiniz.<\/p>\n<p>Ayr\u0131ca, bu konuda daha fazla bilgi edinmek i\u00e7in \u015fu kaynaklar\u0131 inceleyebilirsiniz: <a href=\"https:\/\/dev.to\/judith677\/calculate-the-hierarchy-of-recursive-references-from-sql-to-spl-11-4kmp\">Dev.to Makalesi<\/a> (\u0130ngilizce).<\/p>\n<h3>Anahtar Kelimeler:<\/h3>\n<p>#SQL #SPL #\u00d6zyineleme #Hiyerar\u015fi #Recursive #Referans #Veritaban\u0131 #Programlama #Algoritma<\/p>\n<p><\/body><br \/>\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi Veritaban\u0131 y\u00f6netiminde, \u00f6zellikle hiyerar\u015fik verileri i\u015flemek i\u00e7in s\u0131kl\u0131kla \u00f6zyinelemeli referanslara ihtiya\u00e7 duyar\u0131z.&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-15596","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL ve SPL&#039;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi<\/title>\n<meta name=\"description\" content=\"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.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL ve SPL&#039;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi\" \/>\n<meta property=\"og:description\" content=\"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.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-19T03:15:14+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi\",\"datePublished\":\"2025-03-19T03:15:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\"},\"wordCount\":426,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\",\"name\":\"SQL ve SPL'de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-03-19T03:15:14+00:00\",\"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.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL ve SPL'de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi","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.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL ve SPL'de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi","og_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.","og_url":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-03-19T03:15:14+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi","datePublished":"2025-03-19T03:15:14+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/"},"wordCount":426,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/","url":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/","name":"SQL ve SPL'de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-03-19T03:15:14+00:00","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.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/sql-ve-splde-ozyinelemeli-referanslarin-hiyerarsisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL ve SPL&#8217;de \u00d6zyinelemeli Referanslar\u0131n Hiyerar\u015fisi"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/15596","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=15596"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/15596\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=15596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=15596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=15596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}