{"id":8949,"date":"2019-05-07T20:29:05","date_gmt":"2019-05-07T20:29:05","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8949"},"modified":"2019-07-30T11:10:53","modified_gmt":"2019-07-30T11:10:53","slug":"pl-sql-programlama-8","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-programlama-8\/","title":{"rendered":"PL\/SQL Programlama -8"},"content":{"rendered":"

Merhaba PL\/SQL yaz\u0131lar\u0131na devam ediyoruz. Bir \u00f6nceki yaz\u0131da d\u00f6ng\u00fclere ba\u015flam\u0131\u015ft\u0131k bu yaz\u0131da da d\u00f6ng\u00fclere devam edip bitirece\u011fiz, bir sonrak, yaz\u0131da da prosed\u00fcr ve fonksiyonlar\u0131 g\u00f6rece\u011fiz. \u015eimdi kald\u0131\u011f\u0131m\u0131z yerden devam edelim.<\/p>\n

WHILE LOOP:<\/h4>\n

Bu d\u00f6ng\u00fc yap\u0131s\u0131nda ko\u015ful sa\u011fland\u0131\u011f\u0131 s\u00fcrece \u00e7al\u0131\u015facak olan kod blo\u011fu \u00e7al\u0131\u015f\u0131r.<\/p>\n

\n
\n
<\/div>\n

\"\"<\/p>\n<\/div>\n

Bir \u00f6rnek ile devam edelim 1 ile 50 aras\u0131ndaki tek say\u0131lar\u0131n toplam\u0131n\u0131 bulal\u0131m;<\/div>\n<\/div>\n
<\/div>\n
DECLARE\r\n\r\nilk_sayi NUMBER;\r\n\r\nson_sayi NUMBER;\r\n\r\ntoplam NUMBER DEFAULT 0;\r\n\r\nBEGIN\r\n\r\nson_sayi:=50;\r\n\r\nilk_sayi:=1;\r\n\r\nWHILE(ilk_say\u0131 < son_sayi)\r\n\r\nLOOP\r\n\r\ntoplam:=toplam+ilk_sayii;\r\n\r\nilk_sayi:=ilk_sayi+2;\r\n\r\nEND LOOP\r\n\r\nDBMS_OUTPUT.PUT_LINE('Tek saylarin toplami ='||toplam);\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
\"\"<\/div>\n
<\/div>\n
FOR LOOP:<\/h4>\n
Bu d\u00f6ng\u00fcde belli bir say\u0131da tekrarlanacak olan kod bloklar\u0131n\u0131n kullan\u0131labilece\u011fi d\u00f6ng\u00fc tipidir. Bir \u00f6rnek ile anlamaya \u00e7al\u0131\u015fal\u0131m.<\/p>\n
1 ile 10 aras\u0131ndaki say\u0131lar\u0131 ekrana yazal\u0131m.<\/p>\n
BEGIN\r\n\r\nFOR i IN 1..10 LOOP\r\n\r\nDBMS_OUTPUT.PUT_LINE('SAYI = '||TO_CHAR(\u0130));\r\n\r\nEND LOOP;\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
\"\"<\/p>\n
Reverse FOR LOOP:<\/h4>\n
FOR LOOP d\u00f6ng\u00fcs\u00fcnde yap\u0131lacak d\u00f6ng\u00fc de\u011ferlerinin tersten ilerleyece\u011fi i\u015flemlerde IN<\/strong> yan\u0131na REVERSE <\/strong>kullanarak i\u015flemleri ger\u00e7ekle\u015ftiririz.<\/p>\n
BEGIN\r\n\r\nFOR i IN REVERSE 1..10 LOOP\r\n\r\nDBMS_OUTPUT.PUT_LINE('SAYI = '||TO_CHAR(\u0130));\r\n\r\nEND LOOP;\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
FOR LOOP -EXIT :<\/h4>\n
FOR d\u00f6ng\u00fcm\u00fczde al\u0131nacak veriye g\u00f6re d\u00f6ng\u00fcm\u00fcz erken bitebilir bu durumlarda EXIT ile ak\u0131\u015f\u0131 sonland\u0131rabiliriz. \u00d6rnek \u00fczerinden devam edelim,<\/p>\n
DECLARE\r\n\r\nilkdeger NUMBER:=1;\r\n\r\nsondeger NUMBER:=5;\r\n\r\nsayibul NUMBER:=3;\r\n\r\nBEGIN\r\n\r\nFOR sayi IN ilkdeger..sondeger\r\n\r\nLOOP\r\n\r\nDBMS_OUTPUT.PUT_LINE('Sayi = '||sayi);\r\n\r\nEXIT WHEN sayi=sayibul;\r\n\r\nEND LOOP;\r\n\r\nEND;\r\n\r\n\/<\/pre>\n
\"\"<\/p>\n
B\u00f6ylelikle d\u00f6ng\u00fcler konusunu bitirmi\u015f olduk gelecek yaz\u0131da fonksiyon ve prosed\u00fcrlere ba\u015flayaca\u011f\u0131z g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba PL\/SQL yaz\u0131lar\u0131na devam ediyoruz. Bir \u00f6nceki yaz\u0131da d\u00f6ng\u00fclere ba\u015flam\u0131\u015ft\u0131k bu yaz\u0131da da d\u00f6ng\u00fclere devam edip bitirece\u011fiz, bir sonrak, yaz\u0131da da prosed\u00fcr ve fonksiyonlar\u0131 g\u00f6rece\u011fiz. \u015eimdi kald\u0131\u011f\u0131m\u0131z yerden devam edelim. WHILE LOOP: Bu d\u00f6ng\u00fc yap\u0131s\u0131nda ko\u015ful sa\u011fland\u0131\u011f\u0131 s\u00fcrece \u00e7al\u0131\u015facak olan kod blo\u011fu \u00e7al\u0131\u015f\u0131r. Bir \u00f6rnek ile devam edelim 1 ile 50 aras\u0131ndaki tek say\u0131lar\u0131n toplam\u0131n\u0131 …<\/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-8949","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\/8949","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=8949"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8949\/revisions"}],"predecessor-version":[{"id":8956,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8949\/revisions\/8956"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}