{"id":8491,"date":"2019-04-20T08:13:04","date_gmt":"2019-04-20T08:13:04","guid":{"rendered":"https:\/\/ittutorial.org\/?p=8491"},"modified":"2019-07-30T11:11:53","modified_gmt":"2019-07-30T11:11:53","slug":"pl-sql-programlama-4","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-programlama-4\/","title":{"rendered":"PL\/SQL Programlama-4"},"content":{"rendered":"

Merhabai PL\/SQL Programlama yaz\u0131lar\u0131na devam ediyoruz, bir \u00f6nceki yaz\u0131mda fonksiyon, prosed\u00fcr bloklar\u0131ndan bahsetmi\u015ftik bug\u00fcn karakter setleri ve veri tiplerine bakaca\u011f\u0131z bir \u00f6nceki yaz\u0131ya buradan<\/a> ula\u015fabilir.<\/p>\n

\"\"<\/p>\n

 <\/p>\n\n

 <\/p>\n

 <\/p>\n

Tablo da i\u015faretler ve anlamlar\u0131 g\u00f6r\u00fclmekte.<\/p>\n

\u00d6nceden Tan\u0131ml\u0131 Veri Tipleri:<\/h5>\n

Bu k\u0131s\u0131m biraz s\u0131k\u0131c\u0131 ge\u00e7ebilir veri tiplerini k\u0131sa k\u0131sa inceleyip bitirece\u011fiz.<\/p>\n

Numeric<\/strong> : Aritmetik i\u015flemlerde kulllan\u0131lan say\u0131sal de\u011ferleri i\u00e7erir.<\/p>\n

Character<\/strong> : Bir karakter tutan veri tipi<\/p>\n

Boolean<\/strong> : True yada False de\u011ferinden birisini tutar<\/p>\n

Datetime<\/strong> : Tarih ve zaman i\u00e7eren veri tipi<\/p>\n

Number<\/strong> : Say\u0131sal verilerin tutuldu\u011fu aland\u0131r. NUMBER(tam,ondal\u0131k)<\/p>\n

 <\/p>\n\n

 <\/p>\n

 <\/p>\n

PLS_INTEGER<\/strong>–BINARY_INTEGER<\/strong> : Number tipinden farkl\u0131 olarak daha h\u0131zl\u0131 aritmatik i\u015flem yapar ve daha az yer tutar.<\/p>\n

BINARY_FLOAT<\/strong>–BINARY_DOUBLE<\/strong> : Veri tipinde kar\u015f\u0131m\u0131za gelen de\u011ferler f ile sonla\u0131r(5.67f) BINARY_DOUBLE ‘ da d ile sonlan\u0131r.<\/p>\n

VARCHAR2<\/strong>–NVARCHAR2<\/strong> : De\u011fi\u015fken alfan\u00fcmerik veya byte verileri tutuldu\u011fu aland\u0131r, Girildi\u011fi de\u011ferin uzunlu\u011funda alan tutar.<\/p>\n

DECLARE\r\ntest1 VARCHAR2(10):='Oracle';\r\ntest2 VARCHAR2(10):='Oracle ';\r\nBEGIN\r\nIF test1=test2 THEN\r\nDBMS_OUTPUT.PUT_LINE(test1 ||'ile' ||test2||'ayn\u0131d\u0131r');\r\nELSE\r\nDBMS_OUTPUT.PUT_LINE(test1||' ile '||test2||'ayn\u0131 de\u011fildir');\r\nEND IF;\r\nEND;\r\n\/\r\n\r\n\r\n\r\n\r\n<\/pre>\n
\u00d6rnekte test2 de\u011fi\u015fkenimizin sonuna bo\u015fluk karakteri koyal\u0131m ve bir test yapal\u0131m<\/p>\n
\"\"<\/p>\n
TIMESTAMP<\/strong> : Y\u0131l,g\u00fcn ay saat dakika ve saniye verilerini tutar.<\/p>\n
LOB(B\u00fcy\u00fck Nesne) Veri Tipleri:<\/h5>\n
Veri \u00f6zelli\u011fi olarak belli bir veri tipinde olmayan(resim,g\u00f6r\u00fcnt\u00fc vb) verileri tutan veri tipleridir.<\/p>\n
BFILE<\/strong> : Veritaban\u0131 d\u0131\u015f\u0131nda i\u015fletim sistemi \u00fczerinde tutulan b\u00fcy\u00fck binary nesnelerdir. 4GB’ \u0131 ge\u00e7emez.<\/p>\n
 <\/p>\n\n
 <\/p>\n
 <\/p>\n
BLOB<\/strong> : Veritaban\u0131 i\u00e7inde tutulan b\u00fcy\u00fck binary nesnelerdir 8 ie 12TB boyutundad\u0131r.<\/p>\n
CLOB<\/strong> : Karakter verilerinin b\u00fcy\u00fck bloglar halinde olmas\u0131d\u0131r 8 ile 12TB boyutundad\u0131r.<\/p>\n
NCLOB<\/strong> : NLS karakter tipinde Unicode veriler tutar. 8 ile 12TB boyutundad\u0131r.<\/p>\n
DE\u011e\u0130\u015eKENLER:<\/h5>\n
De\u011fi\u015fkenler k\u0131sm\u0131na PL\/SQL Programlama-1 yaz\u0131s\u0131nda de\u011finmi\u015ftim son olarak bahsetmek istedi\u011fim CONSTANT ve DEFAULT kullan\u0131m\u0131n\u0131 a\u00e7\u0131klamak kald\u0131.<\/p>\n
 <\/p>\n\n
 <\/p>\n
 <\/p>\n
CONSTANT<\/strong> de\u011fi\u015fkene sabit bir de\u011fer atamas\u0131 yapmak istedi\u011fimiz zaman kullan\u0131r\u0131z, programlama dillerinde ki static anahtar kelimesine benzetebiliriz.<\/p>\n
DEAULT<\/strong>: De\u011fi\u015fkeni tan\u0131mlarken sabit olmayan ve de\u011fi\u015febilen bir de\u011fer verebiliriz.<\/p>\n
 <\/p>\n\n
 <\/p>\n
Bir sonraki yaz\u0131 da IF-ELSE yap\u0131lar\u0131yla devam ediyor olaca\u011f\u0131z, g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhabai PL\/SQL Programlama yaz\u0131lar\u0131na devam ediyoruz, bir \u00f6nceki yaz\u0131mda fonksiyon, prosed\u00fcr bloklar\u0131ndan bahsetmi\u015ftik bug\u00fcn karakter setleri ve veri tiplerine bakaca\u011f\u0131z bir \u00f6nceki yaz\u0131ya buradan ula\u015fabilir.       Tablo da i\u015faretler ve anlamlar\u0131 g\u00f6r\u00fclmekte. \u00d6nceden Tan\u0131ml\u0131 Veri Tipleri: Bu k\u0131s\u0131m biraz s\u0131k\u0131c\u0131 ge\u00e7ebilir veri tiplerini k\u0131sa k\u0131sa inceleyip bitirece\u011fiz. Numeric : Aritmetik i\u015flemlerde kulllan\u0131lan say\u0131sal …<\/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":[3708,3717,3722,3715,3713,3711,3721,3709,3712,3720,3718,3716,3710,3719],"class_list":["post-8491","post","type-post","status-publish","format-standard","","category-pl-sql-turkce","tag-adim-adim-plsql","tag-oracle-plsql","tag-pl-sql-turkce","tag-pl-sql-tutorial","tag-plsql-baska-tablodan-veri-cekme","tag-plsql-degiskenler","tag-plsql-document","tag-plsql-fonksiyonlar","tag-plsql-insert-kullanimi","tag-plsql-kitaplari","tag-plsql-kurallari","tag-plsql-nedir","tag-plsql-prosedur","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\/8491","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=8491"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8491\/revisions"}],"predecessor-version":[{"id":8750,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/8491\/revisions\/8750"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=8491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=8491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=8491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}