{"id":8608,"date":"2019-04-27T07:19:26","date_gmt":"2019-04-27T07:19:26","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8608"},"modified":"2019-07-30T11:11:40","modified_gmt":"2019-07-30T11:11:40","slug":"pl-sql-programlama-4-2","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-programlama-4-2\/","title":{"rendered":"PL\/SQL Programlama -5"},"content":{"rendered":"

Merhabalar bu yaz\u0131da PL\/SQL Programlama da ak\u0131\u015f \u00f6perat\u00f6rleriyle devam ediyoruz, hen\u00fcz ilk yaz\u0131lara bakmad\u0131ysan\u0131z buradan<\/a> ula\u015fabilirsiniz.<\/p>\n

PL\/SQL’de IF-ELSE gibi yap\u0131lar bir\u00e7ok programlama dilleriyle benzerdir. En basit \u015fekli ile ifade etmek gerekecek olursak bir \u015fart\u0131n istene bir durumda TRUE istenmeyen veya farkl\u0131 bir sonu\u00e7 beklenen durumda FALSE de\u011ferinin d\u00f6nmesiyle sonu\u00e7lan\u0131r.<\/p>\n

\"\"<\/p>\n

 <\/p>\n\n

 <\/p>\n

 <\/p>\n

IF-THEN YAPISI:<\/h6>\n

Temel olarak ko\u015fulun yer ald\u0131\u011f\u0131 IF-THEN s\u00f6z dizimi ve sonras\u0131nda \u00e7al\u0131\u015facak kod blo\u011fu yer al\u0131r. IF-THEN yap\u0131s\u0131 kodun \u00e7al\u0131\u015fmas\u0131ndan sonra END-IF blo\u011fu ile kapat\u0131l\u0131r<\/p>\n

IF ko\u015ful THEN<\/p>\n

PL\/SQL Kodu;<\/p>\n

……..<\/p>\n

…….<\/p>\n

END IF;<\/p>\n

SQL>set serveroutput on;\r\n\r\nDECLARE\r\n\r\nsayi1 NUMBER:=5;\r\n\r\nsayi2 NUMBER:=2;\r\n\r\nfark NUMBER;\r\n\r\nBEGIN\r\n\r\nIF sayi1>sayi2 THEN\r\n\r\nfark:=sayi1-sayi2;\r\n\r\nEND IF;\r\n\r\nDBMS_OUPUT.PUT_LINE('SAYI1 = '||sayi1);\r\n\r\nDBMS_OUPUT.PUT_LINE('SAYI2 = '||sayi2);\r\n\r\nDBMS_OUPUT.PUT_LINE('FARK = '||fark);\r\n\r\nEND;\r\n\/\r\n\r\n\r\n\r\n\r\n<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n\n
 <\/p>\n
 <\/p>\n
IF-THEN-ELSE:<\/h6>\n
Bu yap\u0131 az \u00f6ncekine ek olarak ELSE blo\u011fu i\u00e7ermekte. IF-THEN k\u0131sm\u0131nda ko\u015ful sa\u011flanmad\u0131\u011f\u0131nda \u00e7al\u0131\u015facak olan kodlar\u0131n yer ald\u0131\u011f\u0131 bloktur. \u00d6rnek \u00fczerinden a\u00e7\u0131klamak en \u00f6\u011fretici olacakt\u0131r<\/p>\n
DECLARE\r\n\r\nsayi1 NUMBER:=10;\r\n\r\nsayi2 NUMBER:=5;\r\n\r\nsonuc NUMBER:\r\n\r\nBEGIN\r\n\r\nIF sayi1<sayi2 THEN\r\n\r\nsonuc:=sayi1+sayi2;\r\n\r\nELSE\r\n\r\nsonuc:=sayi1*sayi2;\r\n\r\nEND IF;\r\n\r\nDBMS_OUTPUT.PUT_LINE('Sonu\u00e7 : '||sonuc);\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
 <\/p>\n\n
 <\/p>\n
\"\"<\/p>\n
 <\/p>\n
 <\/p>\n\n
 <\/p>\n
 <\/p>\n
IF-THEN-ELSIF:<\/h6>\n
Yine az \u00f6ncekine benzer mant\u0131kta \u00e7al\u0131\u015fan bir blok yap\u0131s\u0131 ancak burda tek ELSE yap\u0131s\u0131 yerine birden fazla olas\u0131 durum sonu\u00e7lanmak istenmesi durumunda kullan\u0131labilecek blok yap\u0131s\u0131.<\/p>\n
DECLARE\r\n\r\nsayi1 NUMBER:=5;\r\n\r\nsayi2 NUMBER:=4;\r\n\r\nsayi3 NUMBER:=3;\r\n\r\nsonuc NUMBER;\r\n\r\nBEGIN\r\n\r\nIF sayi1<sayi2 THEN\r\n\r\nsonuc:=sayi1+sayi2;\r\n\r\nELSEIF sayi2<sayi3 THEN\r\n\r\nsonuc:=sayi2+sayi3;\r\n\r\nELSEIF sayi3<sayi2 THEN\r\n\r\nsonuc:=sayi3*sayi3;\r\n\r\nELSE\r\n\r\nsonuc:=0;\r\n\r\nEND IF;\r\n\r\nDBMS_OUTPUT.PUT_LINE('Sonu\u00e7 = '||sonuc);\r\n\r\nEND;\r\n\r\n\/\r\n\"\"\r\n\r\n\r\n\r\n\r\n\r\n<\/pre>\n
Ben \u00f6rnekleri \u00e7ok basit \u015fekilde anlatmaya \u00e7al\u0131\u015ft\u0131m ancak IF-THEN vb yap\u0131larda karma\u015f\u0131k sorgular veya DML,DDL i\u015flemleri yap\u0131labilir. Herhangi bir ko\u015ful sa\u011fland\u0131\u011f\u0131nda bir tablo UPDATE edilebilir veya sa\u011flanmad\u0131\u011f\u0131nda farkl\u0131 bir INSERT girilebilir. Bunun gibi \u00f6rnekleri \u00e7o\u011faltmak m\u00fcmk\u00fcn.<\/p>\n
Bu yaz\u0131’y\u0131 burada b\u0131rakal\u0131m bir sonraki yaz\u0131 da CASE-WHEN ve nested IF-THEN yap\u0131lar\u0131na bak\u0131yor olaca\u011f\u0131z, g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhabalar bu yaz\u0131da PL\/SQL Programlama da ak\u0131\u015f \u00f6perat\u00f6rleriyle devam ediyoruz, hen\u00fcz ilk yaz\u0131lara bakmad\u0131ysan\u0131z buradan ula\u015fabilirsiniz. PL\/SQL’de IF-ELSE gibi yap\u0131lar bir\u00e7ok programlama dilleriyle benzerdir. En basit \u015fekli ile ifade etmek gerekecek olursak bir \u015fart\u0131n istene bir durumda TRUE istenmeyen veya farkl\u0131 bir sonu\u00e7 beklenen durumda FALSE de\u011ferinin d\u00f6nmesiyle sonu\u00e7lan\u0131r.       IF-THEN YAPISI: Temel …<\/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":[3618,3622,3630,3658,3911,3905,3906,3907,3908,3909,3910,3632,3666,3912,3904,3705,3722,3715],"class_list":["post-8608","post","type-post","status-publish","format-standard","","category-pl-sql-turkce","tag-pl-sql","tag-pl-sql-baslangic","tag-pl-sql-dersleri","tag-pl-sql-document","tag-pl-sql-examples","tag-pl-sql-fonkfiyonlar","tag-pl-sql-fonksiyonlar","tag-pl-sql-if-else","tag-pl-sql-if-then","tag-pl-sql-if-then-else","tag-pl-sql-if-then-elsif","tag-pl-sql-nedir","tag-pl-sql-ogrenmek","tag-pl-sql-ornek-kodlama","tag-pl-sql-programing","tag-pl-sql-programlama","tag-pl-sql-turkce","tag-pl-sql-tutorial"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8608","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=8608"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8608\/revisions"}],"predecessor-version":[{"id":8617,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8608\/revisions\/8617"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}