{"id":6405,"date":"2026-02-18T19:58:45","date_gmt":"2026-02-18T19:58:45","guid":{"rendered":"https:\/\/bentego.com\/?p=6405"},"modified":"2026-02-26T20:00:18","modified_gmt":"2026-02-26T20:00:18","slug":"oracle-sqlde-prosedur-olusturma","status":"publish","type":"post","link":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/","title":{"rendered":"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma"},"content":{"rendered":"\n<p id=\"ac0a\">Merhabalar, bir \u00f6nceki yaz\u0131mda prosed\u00fcr yazman\u0131n avantajlar\u0131ndan ve faydalar\u0131ndan bahsetmi\u015ftim. Bu yaz\u0131da ise prosed\u00fcr nas\u0131l olu\u015fturulur, bu s\u00fcre\u00e7 nas\u0131l ilerler ve sonucunda elde etti\u011fimiz faydadan bahsedece\u011fim.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/v2\/resize:fit:1400\/1*_IFpWFD19K0WwiGw262pCA.png\" alt=\"\"\/><\/figure>\n\n\n\n<p id=\"9c1c\">Kurumsal ortamlarda \u00e7al\u0131\u015f\u0131rken devasa kaynak tablolarla u\u011fra\u015fmak veri i\u015fleme ve raporlama s\u00fcre\u00e7lerinde ciddi bir yava\u015fl\u0131\u011fa neden olabiliyor. Bu tablolar y\u00fczlerce kolondan olu\u015fabiliyor, eri\u015fim yetkiniz s\u0131n\u0131rl\u0131 olabiliyor ya da do\u011frudan sorguyu h\u0131zland\u0131rmak i\u00e7in belirli kolonlara index atama gibi i\u015flemleri yapmam\u0131z m\u00fcmk\u00fcn olmayabiliyor. Bu gibi durumlarda, ihtiyaca \u00f6zel sadele\u015ftirilmi\u015f ara tablolar olu\u015fturarak hem performans\u0131 art\u0131rmak hem de s\u00fcreci daha y\u00f6netilebilir hale getirmek m\u00fcmk\u00fcnd\u00fcr.<\/p>\n\n\n\n<p id=\"f2a2\">Bunun i\u00e7in ilk ad\u0131m olan prosed\u00fcr\u00fc olu\u015fturmak i\u00e7in veri taban\u0131na ba\u011flan\u0131p sonra prosed\u00fcr sekmesine ula\u015f\u0131p \u00fczerine t\u0131klanarak prosed\u00fcr olu\u015fturulur. \u0130sim verme gibi ad\u0131mlardan sonra prosed\u00fcr\u00fcm\u00fcz haz\u0131r olacakt\u0131r. Bu k\u0131sm\u0131n devam\u0131nda \u00f6nemli olan ise bu prosed\u00fcr\u00fcn \u00e7al\u0131\u015fma \u015feklidir. DROP-CREATE \u015feklinde mi yoksa TRUNCATE-INSERT \u015feklinde mi belirlememiz gerekmektedir.<\/p>\n\n\n\n<p id=\"bfdd\">E\u011fer tablo, prosed\u00fcr i\u00e7erisinde TRUNCATE komutu ile temizlenip tekrar kullan\u0131lacak \u015fekilde planlanm\u0131\u015fsa, bu tablonun \u00f6ncesinde veri taban\u0131nda bir defaya mahsus olarak manuel \u015fekilde create edilmesi gerekir.<\/p>\n\n\n\n<p id=\"c4ae\">Veri taban\u0131na ait bir sayfada veya veri taban\u0131 \u00fczerinden tablolar sekmesinden tabloyu olu\u015fturabiliriz. Bizim \u00f6rnek olarak olu\u015fturaca\u011f\u0131m\u0131z veri tablosu, son \u00fc\u00e7 ay\u0131n hepsinde de a\u015f\u0131m yapan m\u00fc\u015fterileri bulunduran tablo olacak.<\/p>\n\n\n\n<p id=\"5a8f\">\u00d6nce tabloyu create ediyoruz. \u0130stedi\u011fimiz kolonlar\u0131 ve veri tiplerini belirtiyoruz.<\/p>\n\n\n\n<p id=\"b209\">CREATE TABLE ETL.ASIM_LAST_3_MONTHS (<\/p>\n\n\n\n<p id=\"9330\">GSM_NO VARCHAR2(20),<\/p>\n\n\n\n<p id=\"bc2e\">TL_ASIM NUMBER<\/p>\n\n\n\n<p id=\"4d71\">);<\/p>\n\n\n\n<p id=\"c409\">Performans ihtiyac\u0131na g\u00f6re tablodaki kolona\/kolonlara index create ediyoruz.<\/p>\n\n\n\n<p id=\"1d7a\">CREATE INDEX IDX_ASIM_GSM_NO ON ETL.ASIM_LAST_3_MONTHS (GSM_NO);<\/p>\n\n\n\n<p id=\"d5e7\">E\u011fer bizim veri taban\u0131m\u0131zda olu\u015fturaca\u011f\u0131m\u0131z tabloya eri\u015fim ihtiyac\u0131 olan kullan\u0131c\u0131lar var ise gerekli kullan\u0131c\u0131 yetkilerini tan\u0131mlamam\u0131z gerekir. \u00d6rnek SELECT yetkisi tan\u0131mlama a\u015fa\u011f\u0131daki gibidir:<\/p>\n\n\n\n<p id=\"228d\">GRANT SELECT ON ETL.ASIM_LAST_3_MONTHS TO USER;<\/p>\n\n\n\n<p id=\"c815\">Tablo olu\u015fturma, index olu\u015fturma ve user yetki verme sonras\u0131 prosed\u00fcr\u00fcm\u00fcze geri d\u00f6nebiliriz. Bu k\u0131s\u0131mda da ilgili kaynak tablodan hangi verileri \u00e7ekece\u011fimizi, nas\u0131l \u00e7ekece\u011fimizi belirlememiz gerekmektedir.<\/p>\n\n\n\n<p id=\"6ee9\">A\u015fa\u011f\u0131daki prosed\u00fcr, kaynak tablo CUSTOMER_PROFILE\u2019dan yaln\u0131zca ihtiyac\u0131m\u0131z olan verileri s\u00fcz\u00fcp \u00f6zetleyerek ETL.ASIM_LAST_3_MONTHS tablosuna aktar\u0131yor. B\u00f6ylelikle kaynak tabloda ya\u015fayabilece\u011fimiz yanl\u0131\u015f yap\u0131labilecek i\u015flemleri; delete, update vb. engelliyor, sorgu s\u00fcreleri k\u0131saltabiliyor, istedi\u011fimiz verinin miktar\u0131n\u0131 belirleyebiliyor ve \u00e7ekti\u011fimiz veri \u00fczerinde oynama imk\u00e2n\u0131 tan\u0131yor. \u00d6rnek prosed\u00fcr a\u015fa\u011f\u0131daki gibidir: Prosed\u00fcr olu\u015ftu\u011funda yapaca\u011f\u0131m\u0131z i\u015flemler begin ve end aras\u0131nda olmal\u0131d\u0131r. Begin \u00fcst k\u0131sm\u0131nda de\u011fi\u015fken tan\u0131mlayabiliriz. Yapt\u0131\u011f\u0131m\u0131z i\u015flemlerde EXECUTE IMMEDIATE diyip do\u011frudan script \u00e7al\u0131\u015ft\u0131r\u0131p commit edebilir veya tan\u0131mlad\u0131\u011f\u0131m\u0131z de\u011fi\u015fken i\u00e7in EXECUTE IMMEDIATE d_task; \u015feklinde de \u00e7al\u0131\u015ft\u0131rabiliriz.<\/p>\n\n\n\n<p id=\"f641\">Buna ek olarak e\u011fer ki \u00e7al\u0131\u015fma s\u00fcrelerini takip etmek istersek yine ek tablo olu\u015fturup tablo i\u00e7erisinde start end gibi kolonlar ekleyerek prosed\u00fcr\u00fcn \u00e7al\u0131\u015fma s\u00fcresi takip edilebilir veya farkl\u0131 uygulamalar \u00fczerinden de prosed\u00fcrlerin periyodik \u00e7al\u0131\u015fmas\u0131 sa\u011flanarak o uygulamalardan da takip edilebilir.<\/p>\n\n\n\n<p id=\"7285\">CREATE OR REPLACE PROCEDURE P_ASIM_LAST_3_MONTHS AS<\/p>\n\n\n\n<p id=\"43b8\">d_task VARCHAR2 (32000);<\/p>\n\n\n\n<p id=\"365e\">v_table_name VARCHAR2(50);<\/p>\n\n\n\n<p id=\"f4a0\">BEGIN<\/p>\n\n\n\n<p id=\"ae46\">\u2014 Veri taban\u0131m\u0131zdaki tabloyu g\u00fcncel tutmak i\u00e7in kaynak tabloya gitmeden \u00f6nce temizleme:<\/p>\n\n\n\n<p id=\"529e\">EXECUTE IMMEDIATE \u2018TRUNCATE TABLE ABC_ETL.ASIM_LAST_3_MONTHS\u2019;<\/p>\n\n\n\n<p id=\"bd80\">v_table_name := \u2018ASIM_LAST_3_MONTHS\u2019;<\/p>\n\n\n\n<p id=\"591c\">\u2014 \u0130stenen veriyi kaynak tablodan \u00e7ekme:<\/p>\n\n\n\n<p id=\"a175\">d_task := \u2018INSERT INTO ABC_ETL.\u2019 || v_table_name ||<\/p>\n\n\n\n<p id=\"efc8\">\u2018(GSM_NO, TL_ASIM)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Get&nbsp;Ercan Ergen\u2019s stories in&nbsp;your&nbsp;inbox<\/h2>\n\n\n\n<p>Join Medium for free to get updates from&nbsp;this&nbsp;writer.Subscribe<\/p>\n\n\n\n<p id=\"50fe\">SELECT GSM_NO, FLOOR(MAX(TOTAL_NET_AMOUNT)) AS TL_ASIM<\/p>\n\n\n\n<p id=\"a0b3\">FROM CUSTOMER_PROFILE<\/p>\n\n\n\n<p id=\"0f00\">WHERE TO_DATE(MONTH_ID,\u2019\u2019YYYYMM\u2019\u2019) &gt;= (<\/p>\n\n\n\n<p id=\"f7f6\">SELECT ADD_MONTHS(TO_DATE(MAX(MONTH_ID),\u2019\u2019YYYYMM\u2019\u2019), -2)<\/p>\n\n\n\n<p id=\"4669\">FROM CUSTOMER_PROFILE)<\/p>\n\n\n\n<p id=\"9c1e\">AND FLOOR(TOTAL_NET_AMOUNT) &gt; 0<\/p>\n\n\n\n<p id=\"e43c\">AND GSM_NO IN (<\/p>\n\n\n\n<p id=\"752d\">SELECT GSM_NO FROM (<\/p>\n\n\n\n<p id=\"de7a\">SELECT GSM_NO<\/p>\n\n\n\n<p id=\"4e6d\">FROM CUSTOMER_PROFILE<\/p>\n\n\n\n<p id=\"82f5\">WHERE TO_DATE(MONTH_ID,\u2019\u2019YYYYMM\u2019\u2019) &gt;= (<\/p>\n\n\n\n<p id=\"b1cf\">SELECT ADD_MONTHS(TO_DATE(MAX(MONTH_ID),\u2019\u2019YYYYMM\u2019\u2019), -2)<\/p>\n\n\n\n<p id=\"ddf7\">FROM CUSTOMER_PROFILE)<\/p>\n\n\n\n<p id=\"3042\">AND FLOOR(TOTAL_NET_AMOUNT) &gt; 0)<\/p>\n\n\n\n<p id=\"d533\">GROUP BY GSM_NO<\/p>\n\n\n\n<p id=\"9292\">HAVING COUNT(*) = 3)<\/p>\n\n\n\n<p id=\"78cc\">GROUP BY GSM_NO \u2018;<\/p>\n\n\n\n<p id=\"bbc3\">EXECUTE IMMEDIATE d_task;<\/p>\n\n\n\n<p id=\"d965\">commit;<\/p>\n\n\n\n<p id=\"c920\">END;<\/p>\n\n\n\n<p id=\"54cd\"><strong>Prosed\u00fcr Ne Yap\u0131yor?<\/strong><\/p>\n\n\n\n<p id=\"6072\">Her \u00e7al\u0131\u015fma \u00f6ncesi g\u00fcncel veriyi tabloya insert etmek i\u00e7in CEP_ETL.ASIM_LAST_3_MONTHS tablosu prosed\u00fcr ba\u015f\u0131nda truncate edilerek eski veriler siliniyor ve tablonun i\u00e7i bo\u015falt\u0131l\u0131yor.<\/p>\n\n\n\n<p id=\"6276\">CUSTOMER_PROFILE tablosundan sadece son 3 aya ait veriler \u00e7ekiliyor. Burada yaln\u0131zca her ay i\u00e7in verisi olan (yani 3 kay\u0131t bulunan) GSM numaralar\u0131 dahil ediliyor.<\/p>\n\n\n\n<p id=\"c491\">d_task, v_table_name gibi de\u011fi\u015fkenler prosed\u00fcr i\u00e7erisinde kullan\u0131l\u0131yor. Bu sayede k\u0131sa ve kolay kullan\u0131m elde edilip, defalarca kullan\u0131lma imk\u00e2n\u0131 sunuyor.<\/p>\n\n\n\n<p id=\"5289\"><strong>Prosed\u00fcr\u00fc Neden Kullan\u0131yoruz?<\/strong><\/p>\n\n\n\n<p id=\"26b2\">CUSTOMER_PROFILE tablosu b\u00fcy\u00fck ve karma\u015f\u0131k: \u00c7ok fazla kolon i\u00e7erdi\u011fi i\u00e7in sadece ihtiyac\u0131m\u0131z olan birka\u00e7 kolonla \u00e7al\u0131\u015fmak daha mant\u0131kl\u0131.<\/p>\n\n\n\n<p id=\"ddd5\">Kaynak tabloda yetkimiz s\u0131n\u0131rl\u0131: Index olu\u015fturmak, tabloyu yeniden d\u00fczenlemek gibi i\u015flemler yapam\u0131yoruz. Ancak kendi olu\u015fturdu\u011fumuz hedef tabloda bu imkanlara sahibiz.<\/p>\n\n\n\n<p id=\"0e3f\">Performans art\u0131\u015f\u0131: K\u00fc\u00e7\u00fck, optimize edilmi\u015f tablolar sorgu s\u00fcresini ciddi oranda k\u0131salt\u0131r. \u00d6rne\u011fin bu prosed\u00fcrle olu\u015fturulan tabloya ileride index eklenebilir ve raporlama i\u015flemleri \u00e7ok daha h\u0131zl\u0131 hale gelebilir.<\/p>\n\n\n\n<p id=\"5631\">Bak\u0131m kolayl\u0131\u011f\u0131: Prosed\u00fcrle \u00e7al\u0131\u015fan yap\u0131lar merkezi olarak kontrol edilebilir. E\u011fer kaynak tabloda bir de\u011fi\u015fiklik olursa sadece prosed\u00fcr\u00fc g\u00fcncelleyerek t\u00fcm s\u00fcreci tekrar d\u00fczene sokmak m\u00fcmk\u00fcnd\u00fcr.<\/p>\n\n\n\n<p id=\"9672\">Sonu\u00e7 olarak bu \u00f6rnek, Oracle PL\/SQL\u2019de prosed\u00fcr yazman\u0131n yaln\u0131zca otomasyon sa\u011flamakla kalmay\u0131p, eri\u015fim ve performans gibi k\u0131s\u0131tlamalara da \u00e7\u00f6z\u00fcm sunabilece\u011fini g\u00f6steriyor. Veriyi sadele\u015ftirerek i\u015f zek\u00e2s\u0131 ve raporlama s\u00fcre\u00e7lerini h\u0131zland\u0131rmak isteyen herkesin bu t\u00fcr yakla\u015f\u0131mlar\u0131 d\u00fc\u015f\u00fcnmesi do\u011frudan istenen veriye h\u0131zl\u0131 ula\u015fmas\u0131n\u0131 sa\u011flarken, kaynak sistemlerde sorun ya\u015faman\u0131n da \u00f6n\u00fcne ge\u00e7mi\u015f olacak.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar, bir \u00f6nceki yaz\u0131mda prosed\u00fcr yazman\u0131n avantajlar\u0131ndan ve faydalar\u0131ndan bahsetmi\u015ftim. Bu yaz\u0131da ise prosed\u00fcr nas\u0131l olu\u015fturulur, bu s\u00fcre\u00e7 nas\u0131l ilerler ve sonucunda [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5926,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[87],"tags":[107,234,108,109,235],"class_list":["post-6405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-oracle-tr","tag-oracle-pl-sql-tr","tag-prosedur","tag-sql-tr","tag-stored-procedure-tr"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma - Bentego<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma - Bentego\" \/>\n<meta property=\"og:description\" content=\"Merhabalar, bir \u00f6nceki yaz\u0131mda prosed\u00fcr yazman\u0131n avantajlar\u0131ndan ve faydalar\u0131ndan bahsetmi\u015ftim. Bu yaz\u0131da ise prosed\u00fcr nas\u0131l olu\u015fturulur, bu s\u00fcre\u00e7 nas\u0131l ilerler ve sonucunda [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/\" \/>\n<meta property=\"og:site_name\" content=\"Bentego\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-18T19:58:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T20:00:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bentego\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bentego\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/\"},\"author\":{\"name\":\"Bentego\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/person\/e38e5868721eddd5493704ec7b5be37c\"},\"headline\":\"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma\",\"datePublished\":\"2026-02-18T19:58:45+00:00\",\"dateModified\":\"2026-02-26T20:00:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/\"},\"wordCount\":1095,\"publisher\":{\"@id\":\"https:\/\/bentego.com\/tr\/#organization\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"keywords\":[\"Oracle\",\"Oracle Pl Sql\",\"prosed\u00fcr\",\"SQL\",\"Stored Procedure\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"tr\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/\",\"url\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/\",\"name\":\"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma - Bentego\",\"isPartOf\":{\"@id\":\"https:\/\/bentego.com\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"datePublished\":\"2026-02-18T19:58:45+00:00\",\"dateModified\":\"2026-02-26T20:00:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage\",\"url\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"contentUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"width\":2400,\"height\":1600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bentego.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bentego.com\/tr\/#website\",\"url\":\"https:\/\/bentego.com\/tr\/\",\"name\":\"Bentego\",\"description\":\"Turning data into enterprise value\",\"publisher\":{\"@id\":\"https:\/\/bentego.com\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bentego.com\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/bentego.com\/tr\/#organization\",\"name\":\"Bentego\",\"url\":\"https:\/\/bentego.com\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg\",\"contentUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg\",\"width\":433,\"height\":109,\"caption\":\"Bentego\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/person\/e38e5868721eddd5493704ec7b5be37c\",\"name\":\"Bentego\",\"sameAs\":[\"http:\/\/bentego.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma - Bentego","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:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/","og_locale":"tr_TR","og_type":"article","og_title":"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma - Bentego","og_description":"Merhabalar, bir \u00f6nceki yaz\u0131mda prosed\u00fcr yazman\u0131n avantajlar\u0131ndan ve faydalar\u0131ndan bahsetmi\u015ftim. Bu yaz\u0131da ise prosed\u00fcr nas\u0131l olu\u015fturulur, bu s\u00fcre\u00e7 nas\u0131l ilerler ve sonucunda [&hellip;]","og_url":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/","og_site_name":"Bentego","article_published_time":"2026-02-18T19:58:45+00:00","article_modified_time":"2026-02-26T20:00:18+00:00","og_image":[{"width":2400,"height":1600,"url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","type":"image\/png"}],"author":"Bentego","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Bentego","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#article","isPartOf":{"@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/"},"author":{"name":"Bentego","@id":"https:\/\/bentego.com\/tr\/#\/schema\/person\/e38e5868721eddd5493704ec7b5be37c"},"headline":"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma","datePublished":"2026-02-18T19:58:45+00:00","dateModified":"2026-02-26T20:00:18+00:00","mainEntityOfPage":{"@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/"},"wordCount":1095,"publisher":{"@id":"https:\/\/bentego.com\/tr\/#organization"},"image":{"@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage"},"thumbnailUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","keywords":["Oracle","Oracle Pl Sql","prosed\u00fcr","SQL","Stored Procedure"],"articleSection":["Blog"],"inLanguage":"tr"},{"@type":"WebPage","@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/","url":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/","name":"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma - Bentego","isPartOf":{"@id":"https:\/\/bentego.com\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage"},"image":{"@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage"},"thumbnailUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","datePublished":"2026-02-18T19:58:45+00:00","dateModified":"2026-02-26T20:00:18+00:00","breadcrumb":{"@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#primaryimage","url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","contentUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","width":2400,"height":1600},{"@type":"BreadcrumbList","@id":"https:\/\/bentego.com\/tr\/oracle-sqlde-prosedur-olusturma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bentego.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Oracle SQL\u2019de Prosed\u00fcr Olu\u015fturma"}]},{"@type":"WebSite","@id":"https:\/\/bentego.com\/tr\/#website","url":"https:\/\/bentego.com\/tr\/","name":"Bentego","description":"Turning data into enterprise value","publisher":{"@id":"https:\/\/bentego.com\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bentego.com\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/bentego.com\/tr\/#organization","name":"Bentego","url":"https:\/\/bentego.com\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg","contentUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg","width":433,"height":109,"caption":"Bentego"},"image":{"@id":"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/bentego.com\/tr\/#\/schema\/person\/e38e5868721eddd5493704ec7b5be37c","name":"Bentego","sameAs":["http:\/\/bentego.com"]}]}},"_links":{"self":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/comments?post=6405"}],"version-history":[{"count":2,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6405\/revisions"}],"predecessor-version":[{"id":6408,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6405\/revisions\/6408"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/media\/5926"}],"wp:attachment":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/media?parent=6405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/categories?post=6405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/tags?post=6405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}