{"id":8430,"date":"2019-04-17T08:25:40","date_gmt":"2019-04-17T08:25:40","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8430"},"modified":"2019-07-30T11:12:25","modified_gmt":"2019-07-30T11:12:25","slug":"pl-sql-1","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-1\/","title":{"rendered":"PL\/SQL Programlama -1"},"content":{"rendered":"<p>Merhaba, yeni bir yaz\u0131 serisine ba\u015fl\u0131yorum. Bu seride PL\/SQL ile \u00f6rnekler yap\u0131p nas\u0131l kullan\u0131ld\u0131\u011f\u0131na ve neler yap\u0131ld\u0131\u011f\u0131na de\u011finece\u011fim.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>PL\/SQL, Oracle firmas\u0131 taraf\u0131ndan geli\u015ftirilmi\u015f SQL sorgu dilinin yaz\u0131l\u0131m dillerine ait \u00f6zelliklerinin eklenmesiyle olu\u015fturulmu\u015f bir programlama dilidir. Prosed\u00fcrel bir yap\u0131da oldu\u011fundan kod i\u00e7erisinde SQL&#8217;in yapamayacaklar\u0131n\u0131 yapabilmektedir.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>Resimde PL\/SQL mimarisi g\u00f6sterilmektedir. Yaz\u0131lan kod iki farkl\u0131 ortamda i\u015flenerek geri d\u00f6ner. Geli\u015ftirilen kod prosed\u00fcr ve normal SQL sorgusu olarak ikiye ayr\u0131ld\u0131\u011f\u0131nda, SQL taraf\u0131 veritaban\u0131nda veriyi ald\u0131\u011f\u0131, prosed\u00fcr&#8217;\u00fcn ise yaz\u0131l\u0131m dili olarak SQL&#8217;in yapamayaca\u011f\u0131 i\u015fleri yapt\u0131\u011f\u0131n\u0131 s\u00f6yleyebiliriz.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/appdev.102\/b14261\/lnpls004.gif\" alt=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/appdev.102\/b14261\/lnpls004.gif\" width=\"461\" height=\"310\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h6>PL\/SQL Temel \u00f6zellikleri:<\/h6>\n<ul>\n<li>Kodlar Blok yap\u0131lar\u0131 i\u00e7inde \u00e7al\u0131\u015fmaktad\u0131r<\/li>\n<li>Prosed\u00fcr, Fonksiyon,Trigger,Paket prosed\u00fcrler programama tekniklerini geli\u015ftirip kullanabilir.<\/li>\n<li>Kendi hata durumlar\u0131m\u0131z\u0131 olu\u015fturu\u011f hata yakalayabiliriz.<\/li>\n<li>Sadece Oracle veritaban\u0131 i\u00e7in kullan\u0131l\u0131r.<\/li>\n<\/ul>\n<h6>PL\/SQL Blok Yap\u0131s\u0131:<\/h6>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>PL\/SQL&#8217;in en temeli DECLARE-BEGIN-END yap\u0131s\u0131nda \u00e7al\u0131\u015f\u0131r. PL\/SQL&#8217;de \u00fc\u00e7 tane blok yap\u0131s\u0131 vard\u0131r;<\/p>\n<ul>\n<li>Basit(Anonim) Blok Yap\u0131s\u0131<\/li>\n<li>Fonksiyon Blok Yap\u0131s\u0131<\/li>\n<li>Prosed\u00fcr Blok Yap\u0131s\u0131<\/li>\n<\/ul>\n<p>Bu yaz\u0131m\u0131 burada noktal\u0131yorum, bir sonraki yaz\u0131 da Basit blok yap\u0131s\u0131yla devam edece\u011fiz, G\u00f6r\u00fc\u015fmek \u00dczere..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba, yeni bir yaz\u0131 serisine ba\u015fl\u0131yorum. Bu seride PL\/SQL ile \u00f6rnekler yap\u0131p nas\u0131l kullan\u0131ld\u0131\u011f\u0131na ve neler yap\u0131ld\u0131\u011f\u0131na de\u011finece\u011fim. &nbsp; &nbsp; PL\/SQL, Oracle firmas\u0131 taraf\u0131ndan geli\u015ftirilmi\u015f SQL sorgu dilinin yaz\u0131l\u0131m dillerine ait \u00f6zelliklerinin eklenmesiyle olu\u015fturulmu\u015f bir programlama dilidir. Prosed\u00fcrel bir yap\u0131da oldu\u011fundan kod i\u00e7erisinde SQL&#8217;in yapamayacaklar\u0131n\u0131 yapabilmektedir. &nbsp; &nbsp; Resimde PL\/SQL mimarisi g\u00f6sterilmektedir. Yaz\u0131lan kod iki &hellip;<\/p>\n","protected":false},"author":67,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5631],"tags":[3619,3626,3635,3617,3624,1340,3618,3622,3629,3630,3628,3625,3627,3636,3632,3631,3623,1572,3620,3621,3633,3634],"class_list":["post-8430","post","type-post","status-publish","format-standard","","category-pl-sql-turkce","tag-basic-pl-sql","tag-declare-begin-end","tag-neden-pl-sql-kullanmaliyiz","tag-oracle-pl-sql","tag-oracle-prosedur","tag-oracle-sql","tag-pl-sql","tag-pl-sql-baslangic","tag-pl-sql-baslangic-dersleri","tag-pl-sql-dersleri","tag-pl-sql-document-series","tag-pl-sql-engine","tag-pl-sql-function","tag-pl-sql-ne-ise-yarar","tag-pl-sql-nedir","tag-pl-sql-ogrenme","tag-prosedur","tag-sql","tag-start-pl-sql","tag-temel-pl-sql","tag-what-is-pl-sql","tag-why-pl-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=8430"}],"version-history":[{"count":6,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8430\/revisions"}],"predecessor-version":[{"id":10627,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8430\/revisions\/10627"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}