{"id":8445,"date":"2019-04-17T21:11:31","date_gmt":"2019-04-17T21:11:31","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8445"},"modified":"2019-07-30T11:12:15","modified_gmt":"2019-07-30T11:12:15","slug":"pl-sql-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-2\/","title":{"rendered":"PL\/SQL Programlama-2"},"content":{"rendered":"<p>Merhaba, PL\/SQL yaz\u0131lar\u0131na devam ediyorum .Bir \u00f6nceki yaz\u0131m\u0131 okumad\u0131ysan\u0131z \u00f6ncelikle oradan ba\u015flaman\u0131z\u0131 tavsiye ederim.\u00a0<a href=\"https:\/\/ittutorial.org\/pl-sql-1\/\">https:\/\/ittutorial.org\/pl-sql-1\/<\/a> . Bu yaz\u0131da PL\/SQL&#8217;i biraz daha yak\u0131ndan tan\u0131yaca\u011f\u0131z.<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<h6>Basit(Anonim) Blok Yap\u0131s\u0131:<\/h6>\n<p>Bu blok yap\u0131s\u0131n\u0131 genel de bir defal\u0131k kod \u00e7al\u0131\u015ft\u0131rmalar\u0131nda kullan\u0131r\u0131z. Di\u011fer blok yap\u0131lar\u0131nda g\u00f6rece\u011fimiz gibi veritaban\u0131nda bir obje olarak saklanmazlar.<\/p>\n<p><strong>DECLARE<\/strong><\/p>\n<ul>\n<li>De\u011fi\u015fkenler<\/li>\n<li>Sabitler<\/li>\n<li>\u0130mle\u00e7<\/li>\n<li>Hata Durumu<\/li>\n<\/ul>\n<p><strong>BEGIN<\/strong><\/p>\n<ul>\n<li>SQL kodu<\/li>\n<li>PL\/SQL kodu<\/li>\n<\/ul>\n<p><strong>EXCEPTION(Opsiyonel)<\/strong><\/p>\n<ul>\n<li>Hata Durumu<\/li>\n<\/ul>\n<p><strong>END;<\/strong><\/p>\n<p><em><strong>DECLARE<\/strong> <\/em>: Ram i\u00e7inde tutaca\u011f\u0131m\u0131z ge\u00e7ici alanlar\u0131n tan\u0131mlar\u0131 yap\u0131l\u0131r<\/p>\n<p><em><strong>BEGIN-END:<\/strong><\/em> SQL ve PL\/SQL kodlar\u0131n\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131 aland\u0131r, operat\u00f6rler ve d\u00f6ng\u00fcler bu alanda kullan\u0131l\u0131r.<\/p>\n<p><strong><em>EXCEPTION:<\/em><\/strong> Olu\u015fabilecek hata durumlar\u0131 yakalan\u0131r ve yap\u0131lmas\u0131 gerekenler yaz\u0131l\u0131r.<\/p>\n<p>K\u00fc\u00e7\u00fck bir \u00f6rnek yapal\u0131m<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<pre>SQL&gt; DECLARE\r\nsayi NUMBER;\r\nisim varchar2(30);\r\nBEGIN\r\nsayi:=1;\r\nisim:='Deniz Parlak';\r\nDBMS_OUTPUT.PUT_LINE(isim ||' '||sayi);\r\nEND;\r\n\/<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8455\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_37-1-300x137.png\" alt=\"\" width=\"545\" height=\"249\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_37-1-300x137.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_37-1.png 439w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi DBMS_OUTPUT.PUT_LINE fonksiyonu sayesinde(bu dilin hello world&#8217;\u00fc ) ekrana de\u011fi\u015fkenlerimizin i\u00e7eriklerini yazd\u0131rabildir.<\/p>\n<p>Birde i\u00e7 i\u00e7e kullan\u0131m \u00f6rne\u011fi yapal\u0131m.<\/p>\n<pre>SQL&gt; DECLARE\r\nisim varchar(20);\r\nBEGIN\r\nisim:='Yasar Kemal';\r\nDECLARE\r\neser varchar2(20);\r\nBEGIN\r\neser:='Ince Memed';\r\nDBMS_OUTPUT.PUT_LINE(isim ||' '|| eser);\r\nEND;\r\nEND;\r\n\/\r\n\r\n\r\n\r\n<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8457\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_38-1-300x159.png\" alt=\"\" width=\"589\" height=\"312\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_38-1-300x159.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/Screenshot_38-1.png 448w\" sizes=\"auto, (max-width: 589px) 100vw, 589px\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>En basit \u015fekilde bir PL\/SQL \u00f6rne\u011fi yapm\u0131\u015f olduk. Bu yaz\u0131y\u0131 burada noktal\u0131yorum, bir sonraki yaz\u0131 da Fonksiyon ve Prosed\u00fcr blo\u011fundan devam edece\u011fim g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba, PL\/SQL yaz\u0131lar\u0131na devam ediyorum .Bir \u00f6nceki yaz\u0131m\u0131 okumad\u0131ysan\u0131z \u00f6ncelikle oradan ba\u015flaman\u0131z\u0131 tavsiye ederim.\u00a0https:\/\/ittutorial.org\/pl-sql-1\/ . Bu yaz\u0131da PL\/SQL&#8217;i biraz daha yak\u0131ndan tan\u0131yaca\u011f\u0131z. &nbsp; &nbsp; Basit(Anonim) Blok Yap\u0131s\u0131: Bu blok yap\u0131s\u0131n\u0131 genel de bir defal\u0131k kod \u00e7al\u0131\u015ft\u0131rmalar\u0131nda kullan\u0131r\u0131z. Di\u011fer blok yap\u0131lar\u0131nda g\u00f6rece\u011fimiz gibi veritaban\u0131nda bir obje olarak saklanmazlar. DECLARE De\u011fi\u015fkenler Sabitler \u0130mle\u00e7 Hata Durumu BEGIN SQL &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":[3660,3664,3626,3667,3618,3670,3668,3673,3630,3658,3672,3659,3661,3632,3666,3671,3662,3669,3665,3674,3663],"class_list":["post-8445","post","type-post","status-publish","format-standard","","category-pl-sql-turkce","tag-basit-pl-sql-ifadeleri","tag-bastan-sona-pl-sql","tag-declare-begin-end","tag-learning-pl-sql","tag-pl-sql","tag-pl-sql-baslangic-seviyesi","tag-pl-sql-blog","tag-pl-sql-blok-yapisi","tag-pl-sql-dersleri","tag-pl-sql-document","tag-pl-sql-giris","tag-pl-sql-learn","tag-pl-sql-neden-kullanilir","tag-pl-sql-nedir","tag-pl-sql-ogrenmek","tag-pl-sql-turkce-ders","tag-pl-sql-turkce-dersler","tag-pl-sql-yazilari","tag-prosedur-sql","tag-standart-pl-sql","tag-turkce-pl-sql-dersleri"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8445","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=8445"}],"version-history":[{"count":7,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8445\/revisions"}],"predecessor-version":[{"id":10792,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8445\/revisions\/10792"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}