{"id":8622,"date":"2019-04-28T14:02:06","date_gmt":"2019-04-28T14:02:06","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8622"},"modified":"2019-07-30T11:11:28","modified_gmt":"2019-07-30T11:11:28","slug":"pl-sql-programlama-6","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-programlama-6\/","title":{"rendered":"PL\/SQL Programlama-6"},"content":{"rendered":"

Merhaba, PL\/SQL Programlama yaz\u0131 serisinin 6.’s\u0131 ile devam ediyoruz. Bir \u00f6nceki yaz\u0131 da IF-THEN yap\u0131lar\u0131n\u0131 incelemi\u015ftik, o yaz\u0131m\u0131z\u0131 g\u00f6rmeyenler buradan<\/a> ula\u015fabilir.<\/p>\n

 <\/p>\n\n

 <\/p>\n

 <\/p>\n

CASE-WHEN:<\/h6>\n

CASE yap\u0131s\u0131 da ayn\u0131 IF yap\u0131s\u0131nda oldu\u011fu gibi bir ko\u015ful \u00fczerinde i\u015flem yapar, fark\u0131 ise CASE yap\u0131s\u0131 birden farkl\u0131 \u015fart\u0131 kar\u015f\u0131la\u015ft\u0131r\u0131p TRUE yada FALSE de\u011fer d\u00f6nd\u00fcrmektedir. Bu yap\u0131da kar\u015f\u0131la\u015ft\u0131r\u0131lacak ko\u015fullar ve bunlar\u0131n sonu\u00e7lar\u0131 CASE-WHEN-THEN aras\u0131nda yap\u0131l\u0131r ve\u00a0 END-CASE; ile sonlan\u0131r<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n\n

 <\/p>\n

 <\/p>\n

DECLARE\r\n\r\nnot_harf CHAR(1);\r\n\r\nBEGIN\r\n\r\nnot_harf:='C';\r\n\r\nCASE not_harf\r\n\r\nWHEN 'A' THEN DBMS_OUTPUT.PUT_LINE('BA\u015eARILI');\r\n\r\nWHEN 'B' THEN DBMS_OUTPUT.PUT_LINE('\u0130Y\u0130');\r\n\r\nWHEN 'C' THEN DBMS_OUTPUT.PUT_LINE('DAHA \u00c7OK \u00c7ALI\u015eMALI');\r\n\r\nELSE\r\n\r\nDBMS_OUTPUT.PUT_LINE('NOT BULUNAMADI!');\r\n\r\nEND CASE;\r\n\r\nEND\r\n\r\n\/\r\n\"\"\r\n\r\n\r\n\r\n\r\n\r\n<\/pre>\n
SEARCHED CASE:<\/p>\n
Bu CASE yap\u0131s\u0131nda farkl\u0131 olarak when yap\u0131s\u0131ndan \u00f6nce kulland\u0131\u011f\u0131m\u0131z arama ifadesini kullanmayarak WHEN-THEN blo\u011funda ko\u015ful alan\u0131nda kullan\u0131r\u0131z. Sa\u011flanan ko\u015fulda da yap\u0131lan THEN ifadesinden sonra yer alan kod blo\u011fu \u00e7al\u0131\u015facakt\u0131r.<\/p>\n
DECLARE\r\n\r\nnot_harf CHAR(1);\r\n\r\nBEGIN\r\n\r\nnot_harf:='A';\r\n\r\nCASE\r\n\r\nWHEN not_harf:='A' THEN DBMS_OUTPUT.PUT_LINE('BA\u015eARILI');\r\n\r\nWHEN not_harf:='B' THEN DBMS_OUTPUT.PUT_LINE('\u0130Y\u0130');\r\n\r\nWHEN not_harf:='C' THEN DBMS_OUTPUT.PUT_LINE('DAHA \u00c7OK \u00c7ALI\u015eMALI');\r\n\r\nELSE\r\n\r\nDMBS_OUTPUT.PUT_LINE('NOT BULUNAMADI');\r\n\r\nEND CASE;\r\n\r\nEND;\r\n\r\n\/\r\n\r\n\r\n\r\n\r\n\r\n<\/pre>\n
\"\"<\/p>\n
 <\/p>\n\n
 <\/p>\n
 <\/p>\n
Bu yap\u0131 da di\u011feriyle benzer sadece birka\u00e7 sat\u0131r farkl\u0131l\u0131klar\u0131 g\u00f6steriyor, istedi\u011finizi kullanmak size kalm\u0131\u015f.<\/p>\n
Bir sonraki yaz\u0131 da d\u00f6ng\u00fcler ile devam edece\u011fiz g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, PL\/SQL Programlama yaz\u0131 serisinin 6.’s\u0131 ile devam ediyoruz. Bir \u00f6nceki yaz\u0131 da IF-THEN yap\u0131lar\u0131n\u0131 incelemi\u015ftik, o yaz\u0131m\u0131z\u0131 g\u00f6rmeyenler buradan ula\u015fabilir.       CASE-WHEN: CASE yap\u0131s\u0131 da ayn\u0131 IF yap\u0131s\u0131nda oldu\u011fu gibi bir ko\u015ful \u00fczerinde i\u015flem yapar, fark\u0131 ise CASE yap\u0131s\u0131 birden farkl\u0131 \u015fart\u0131 kar\u015f\u0131la\u015ft\u0131r\u0131p TRUE yada FALSE de\u011fer d\u00f6nd\u00fcrmektedir. Bu yap\u0131da kar\u015f\u0131la\u015ft\u0131r\u0131lacak ko\u015fullar …<\/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":[3930,3664,3928,3931,3630,3658,3923,3632,3929,3927,3932,3925,3709,3926,3720,3718,3921,3922,3924,3710,3933,1572,3719],"class_list":["post-8622","post","type-post","status-publish","format-standard","","category-pl-sql-turkce","tag-basit-plsql","tag-bastan-sona-pl-sql","tag-pl-sql-case-when","tag-pl-sql-degiskenler","tag-pl-sql-dersleri","tag-pl-sql-document","tag-pl-sql-lesson","tag-pl-sql-nedir","tag-plsql-baslangic-dersleri","tag-plsql-case-yapisi","tag-plsql-degisken-atama","tag-plsql-donguler","tag-plsql-fonksiyonlar","tag-plsql-if-else","tag-plsql-kitaplari","tag-plsql-kurallari","tag-plsql-learning","tag-plsql-lessons","tag-plsql-ogrenmek","tag-plsql-prosedur","tag-set-serveroputput-on","tag-sql","tag-sql-ve-plsql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8622","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=8622"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8622\/revisions"}],"predecessor-version":[{"id":8754,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8622\/revisions\/8754"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8622"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8622"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8622"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}