{"id":8940,"date":"2019-05-07T16:52:09","date_gmt":"2019-05-07T16:52:09","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8940"},"modified":"2019-07-30T11:11:16","modified_gmt":"2019-07-30T11:11:16","slug":"pl-sql-programlama-7","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-programlama-7\/","title":{"rendered":"PL\/SQL Programlama -7"},"content":{"rendered":"

Merhaba PL\/SQL yaz\u0131lar\u0131na devam ediyoruz ge\u00e7ti\u011fimiz yaz\u0131da CASE-WHEN yap\u0131s\u0131n\u0131 incelemi\u015ftik bu yaz\u0131ya ge\u00e7meden ona g\u00f6z atman\u0131zda fayda var https:\/\/ittutorial.org\/pl-sql-programlama-6\/.\u00a0<\/a><\/p>\n

Bu yaz\u0131da D\u00f6ng\u00fcler’i inceleyece\u011fiz<\/p>\n

D\u00f6ng\u00fcler(Loops):<\/p>\n

Kod yaz\u0131m\u0131nda baz\u0131 i\u015flemlerle \u00e7al\u0131\u015ft\u0131raca\u011f\u0131m\u0131z kod bloklar\u0131n\u0131n belirli aral\u0131kta veya s\u0131ral\u0131 olarak i\u015flem yapma ihtiyac\u0131 duyabiliriz. Bu tarz durumlarda d\u00f6ng\u00fcleri, verece\u011fimiz ko\u015fullarla beraber kullanabiliriz.<\/p>\n

\"\"<\/p>\n

LOOP :<\/strong> En temel d\u00f6ng\u00fc tipidir<\/p>\n

WHILE LOOP:<\/strong> Bir \u015fart\u0131n sa\u011flanmas\u0131 sonucunda \u00e7al\u0131\u015fan d\u00f6ng\u00fcd\u00fcr<\/p>\n

FOR…LOOP:<\/strong> Belirli bir say\u0131da yap\u0131lan i\u015flemler i\u00e7in kullan\u0131l\u0131r<\/p>\n

Nested LOOP:<\/strong> \u0130\u00e7 i\u00e7e yer alan d\u00f6ng\u00fclerdir.<\/p>\n

 <\/p>\n

LOOP Yap\u0131s\u0131:<\/h4>\n

PL\/SQL ‘de en temel d\u00f6ng\u00fc tipidir LOOP-END LOOP blo\u011fu i\u00e7erisinde kodlar \u00e7al\u0131\u015ft\u0131r\u0131l\u0131r<\/p>\n

EXIT Kullan\u0131m\u0131:<\/p>\n

Blok i\u00e7erisinde \u00e7al\u0131\u015ft\u0131r\u0131lan kodlar\u0131n i\u00e7inde EXIT ya da EXIT-WHEN ile bloktan direk \u00e7\u0131karma i\u015flemini yapar<\/p>\n

DECLARE \r\n\r\nsayi NUMBER :=0;\r\n\r\nBEGIN\r\n\r\nLOOP\r\n\r\nDBMS_OUTPUT.PUT_LINE('D\u00f6ng\u00fc i\u00e7inde = ' || TO_CHAR(sayi));\r\n\r\nsayi:=sayi +1;\r\n\r\nIF sayi>5 THEN\r\n\r\nEXIT;\r\n\r\nEND IF;\r\n\r\nEND LOOP;\r\n\r\nDBMS_OUTPUT.PUT_LINE('LOOP D\u00f6ng\u00fcs\u00fc d\u0131\u015f\u0131nda = ' || TO_CHAR(sayi));\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
\"\"<\/p>\n
EXIT WHEN Kullan\u0131m\u0131:<\/h4>\n
Bu yap\u0131 da az \u00f6nce \u00f6rnek yapt\u0131\u011f\u0131m\u0131z IF yap\u0131s\u0131na benzer \u015fekilde \u00e7al\u0131\u015f\u0131r orada IF kullanarak \u00e7\u0131k\u0131\u015f yapm\u0131\u015ft\u0131k burada WHEN ile yapaca\u011f\u0131z.<\/p>\n
DECLARE<\/p>\n
sayi NUMBER:=0;<\/p>\n
BEGIN<\/p>\n
LOOP<\/p>\n
DBMS_OUTPUT.PUT_LINE(‘D\u00f6ng\u00fc i\u00e7inde = ‘ || TO_CHAR(sayi));<\/p>\n
sayi:=sayi+1;<\/p>\n
EXIT WHEN sayi>3;<\/p>\n
END LOOP<\/p>\n
DBMS_OUTPUT.PUT_LINE(‘LOOP D\u00f6ng\u00fcs\u00fc d\u0131\u015f\u0131nda = ‘ || TO_CHAR(sayi));<\/p>\n
END;<\/p>\n
\/<\/p>\n
\"\"<\/p>\n
CONTINUE Kullan\u0131m\u0131:<\/h4>\n
Kod i\u00e7erisinde kullanaca\u011f\u0131m\u0131z ve d\u00f6ng\u00fcn\u00fcn devam\u0131n\u0131 sa\u011flayacak operat\u00f6rd\u00fcr.<\/p>\n
\n
\n
<\/div>\n
\"\"<\/p>\n<\/div>\n
Bir \u00f6rnek ile daha kolay anlayabiliriz;<\/div>\n<\/div>\n
<\/div>\n
DECLARE\r\n\r\nsayi NUMBER:=0;\r\n\r\nBEGIN\r\n\r\nLOOP\r\n\r\nDBMS_OUTPUT.PUT_LINE('LOOP icinde = ' TO_CHAR(sayi));\r\n\r\nsayi:=sayi+1;\r\n\r\nIF sayi >3 THEN\r\n\r\nCONTINUE;\r\n\r\nEND IF;\r\n\r\nDBMS_OUTPUT.PUT_LINE('LOOP icinde CONTINUE sonras\u0131 =' || TO_CHAR(sayi));\r\n\r\nEXIT WHEN sayi=5;\r\n\r\nEND LOOP;\r\n\r\nDBMS_OUTPUT.PUT_LINE('LOOP d\u0131s\u0131nda = ' || TO_CHAR(sayi));\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
\"\"<\/div>\n
<\/div>\n
CONTINUE WHEN Kullan\u0131m\u0131:<\/h4>\n
D\u00f6ng\u00fc i\u00e7erisinde kulland\u0131\u011f\u0131m\u0131z bu operat\u00f6r EXIT WHEN’de oldu\u011fu gibi bir ko\u015fulu denetler ve d\u00f6ng\u00fcn\u00fcn bulundu\u011fu noktadan ba\u015fa d\u00f6nmesini sa\u011flar.<\/p>\n
\u00d6rnek kullan\u0131m\u0131na bakal\u0131m,<\/p>\n
DECLARE\r\n\r\nsayi NUMBER:=0;\r\n\r\nBEGIN\r\n\r\nLOOP\r\n\r\nDBMS_OUTPUT.PUT_LINE('LOOP icinde = '|| TO_CHAR(sayi));\r\n\r\nsayi:=sayi+1;\r\n\r\nCONTINUE WHEN sayi<3;\r\n\r\nDMBS_OUTPUT.PUT_LINE('LOOP icinde, CONTINUE EXIT sonras\u0131 ='||TO_CHAR(sayi));\r\n\r\nEXIT WHEN sayi=5;\r\n\r\nEND LOOP;\r\n\r\nDBMS_OUTPUT.PUT_LINE('LOOP d\u0131\u015f\u0131nda '||TO_CHAR(sayi));\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
\"\"<\/p>\n
\u00d6rnekleri \u00e7o\u011faltmak m\u00fcmk\u00fcn, en basit \u015fekilde anla\u015f\u0131lmas\u0131 i\u00e7in \u00f6rnekleri basit ele ald\u0131k bir sonraki yaz\u0131 da d\u00f6ng\u00fclere devam edece\u011fiz g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba PL\/SQL yaz\u0131lar\u0131na devam ediyoruz ge\u00e7ti\u011fimiz yaz\u0131da CASE-WHEN yap\u0131s\u0131n\u0131 incelemi\u015ftik bu yaz\u0131ya ge\u00e7meden ona g\u00f6z atman\u0131zda fayda var https:\/\/ittutorial.org\/pl-sql-programlama-6\/.\u00a0 Bu yaz\u0131da D\u00f6ng\u00fcler’i inceleyece\u011fiz D\u00f6ng\u00fcler(Loops): Kod yaz\u0131m\u0131nda baz\u0131 i\u015flemlerle \u00e7al\u0131\u015ft\u0131raca\u011f\u0131m\u0131z kod bloklar\u0131n\u0131n belirli aral\u0131kta veya s\u0131ral\u0131 olarak i\u015flem yapma ihtiyac\u0131 duyabiliriz. Bu tarz durumlarda d\u00f6ng\u00fcleri, verece\u011fimiz ko\u015fullarla beraber kullanabiliriz. LOOP : En temel d\u00f6ng\u00fc tipidir WHILE …<\/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-8940","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\/8940","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=8940"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8940\/revisions"}],"predecessor-version":[{"id":8975,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8940\/revisions\/8975"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}