{"id":9675,"date":"2019-06-17T10:49:48","date_gmt":"2019-06-17T10:49:48","guid":{"rendered":"https:\/\/ittutorial.org\/?p=9675"},"modified":"2019-07-30T11:10:20","modified_gmt":"2019-07-30T11:10:20","slug":"pl-sql-programlama-10","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-programlama-10\/","title":{"rendered":"PL\/SQL Programlama – 10"},"content":{"rendered":"

Merhaba, PL\/SQL yaz\u0131lar\u0131na devam ediyoruz,\u00a0 bir \u00f6nceki yaz\u0131ya g\u00f6z atmad\u0131ysan\u0131z \u015furadan<\/a> bakabilirsiniz.<\/p>\n

Bu yaz\u0131da Fonksiyonlar’a ba\u015fl\u0131yoruz. Prosed\u00fcrler ile benzer i\u015fleri yapan ancak farkl\u0131 olarak geriye de\u011fer d\u00f6nd\u00fcren bir yap\u0131d\u0131r.<\/p>\n

Fonksiyon Olu\u015fturma:<\/h5>\n

Fonksiyon olu\u015fturma i\u015fleminin yaz\u0131m kural\u0131 \u015fu \u015fekildedir;<\/p>\n

CREATE [OR REPLACE] FUNCTION<\/strong> fonksiyon_adi [(parametre_adi [IN | OUT | IN OUT] type [, ...])]\r\n\r\nRETURN return_tipi\r\n\r\n{IS | AS} BEGIN\r\n\r\nfonksiyon\r\n\r\nEND (fonksiyon ad\u0131);<\/pre>\n
Fonksiyon olu\u015ftururken dikkat etmemiz gereken birka\u00e7 kural vard\u0131r :<\/p>\n
    \n
  • Ayn\u0131 isimde birden fazla fonksiyon olu\u015fturamay\u0131z<\/li>\n
  • De\u011fer d\u00f6nd\u00fcr\u00fclecekse RETURN komutu kullan\u0131lmak zorundad\u0131r<\/li>\n
  • AS-IS birbiri yerine kullan\u0131labilir<\/li>\n<\/ul>\n
    Bir \u00f6rnek ile devam girdi\u011fimiz tarihe g\u00f6re ya\u015f\u0131 hesaplayan bir fonksiyon yazal\u0131m.<\/p>\n
    CREATE FUNCTION yas_hesapla(dgm_tr date) return number is\r\nBEGIN\r\nRETURN(TRUNC((sysdate-dgm_tr)\/365.25));\r\nEND yas_hesapla;\r\n\/<\/pre>\n
    \u015eimdi do\u011fum tarihimizi girelim ve sonucu g\u00f6relim<\/p>\n
    select yas_hesapla(’20\/02\/1998′) from dual;<\/p>\n
    \"\"<\/p>\n
    Bir \u00f6rnekde tek \u00e7ift say\u0131lar\u0131 bulmak i\u00e7in yapal\u0131m:<\/p>\n
     <\/p>\n
    CREATE OR REPLACE FUNCTION tek_cift(num_in NUMBER) RETURN VARCHAR2\r\n\r\nIS BEGIN\r\n\r\nIF MOD(num_in,2)=0 THEN\r\n\r\nRETURN 'SAYI C\u0130FT';\r\n\r\nELSE\r\n\r\nRETURN 'SAYI TEK';\r\n\r\nEND IF;\r\n\r\nEND tek_cift\r\n\r\n\r\n\r\nSQL> select tek_cift(91) from dual;<\/pre>\n
     <\/p>\n
    \"\"<\/p>\n
    Fonksiyon konusunu burada noktal\u0131yoruz elbette birden fazla \u00f6rnek yapmak m\u00fcmk\u00fcn, t\u00fcm konular\u0131n bitiminde \u00f6rnek kodlar ile \u00e7al\u0131\u015faca\u011f\u0131z,<\/p>\n
    G\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    Merhaba, PL\/SQL yaz\u0131lar\u0131na devam ediyoruz,\u00a0 bir \u00f6nceki yaz\u0131ya g\u00f6z atmad\u0131ysan\u0131z \u015furadan bakabilirsiniz. Bu yaz\u0131da Fonksiyonlar’a ba\u015fl\u0131yoruz. Prosed\u00fcrler ile benzer i\u015fleri yapan ancak farkl\u0131 olarak geriye de\u011fer d\u00f6nd\u00fcren bir yap\u0131d\u0131r. Fonksiyon Olu\u015fturma: Fonksiyon olu\u015fturma i\u015fleminin yaz\u0131m kural\u0131 \u015fu \u015fekildedir; CREATE [OR REPLACE] FUNCTION fonksiyon_adi [(parametre_adi [IN | OUT | IN OUT] type [, …])] RETURN return_tipi …<\/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-9675","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\/9675","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=9675"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/9675\/revisions"}],"predecessor-version":[{"id":9678,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/9675\/revisions\/9678"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=9675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=9675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=9675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}