{"id":10253,"date":"2019-07-01T12:56:44","date_gmt":"2019-07-01T12:56:44","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10253"},"modified":"2019-07-24T08:26:33","modified_gmt":"2019-07-24T08:26:33","slug":"oracle-sql-dersleri-creating-a-table","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-dersleri-creating-a-table\/","title":{"rendered":"ORACLE SQL Dersleri &#8211; Creating a Table"},"content":{"rendered":"<p>Merhaba SQL Yaz\u0131lar\u0131na devam ediyoruz, bu yaz\u0131da tablo olu\u015fturma i\u015flemlerine bakaca\u011f\u0131z. Bir \u00f6nceki yaz\u0131m\u0131zda tablodaki verileri g\u00fcncellemeyi ve silmeyi g\u00f6rm\u00fc\u015ft\u00fck bu yaz\u0131ya ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131m\u0131z\u0131 okuman\u0131z\u0131 tavsiye ederiz,<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"zTYHzlD6PY\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-dersleri-update\/\">ORACLE SQL Dersleri &#8211; Update<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;ORACLE SQL Dersleri &#8211; Update&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-dersleri-update\/embed\/#?secret=5lKnJ4edcb#?secret=zTYHzlD6PY\" data-secret=\"zTYHzlD6PY\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">CREATE TABLE ifadesinin temel kullan\u0131m\u0131 a\u015fa\u011f\u0131daki gibidir :<\/span><\/span><\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">CREATE TABLE<\/span><\/b> table_name\r\n(\r\ncolumn_name1 data_type(size),\r\ncolumn_name2 data_type(size),\r\ncolumn_name3 data_type(size),\r\n....\r\ncolumnN data_type(size)\r\n);<\/span><\/span><\/pre>\n<p>\u00d6rnek ile peki\u015ftirelim,<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><span class=\"tooltip\">CREATE TABLE<\/span> Users\r\n(\r\nUserID <b>int<\/b>,\r\nFirstName <b>varchar<\/b>(100), \r\nLastName <b>varchar<\/b>(100),\r\nCity <b>varchar<\/b>(100)\r\n); <\/span><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10254\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_26.png\" alt=\"\" width=\"1012\" height=\"510\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_26.png 1012w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_26-300x151.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_26-768x387.png 768w\" sizes=\"auto, (max-width: 1012px) 100vw, 1012px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, tablo SYSTEM \u015femas\u0131 alt\u0131nda olu\u015fmu\u015f durumda.<\/p>\n<p>&nbsp;<\/p>\n<h1>SQL Constraints:<\/h1>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">SQL k\u0131s\u0131tlamalar\u0131, tablo verilerinde kurallar\u0131 belirtmek i\u00e7in kullan\u0131l\u0131r.<\/span><\/span><\/p>\n<h4><\/h4>\n<h4>PRIMARY KEY :<\/h4>\n<p>PRIMARY KEY bir tabloda bensersiz kay\u0131tlar yaratmak i\u00e7in kullan\u0131lan bir s\u00f6zc\u00fckt\u00fcr. Ayn\u0131 kay\u0131tlar\u0131 birbirinden ay\u0131rt etmek, tekrarl\u0131 verilerin olu\u015fmas\u0131n\u0131 engellemek i\u00e7in olu\u015fturulur.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><span class=\"tooltip\">CREATE TABLE<\/span> Users\r\n(\r\nUserID int,\r\nFirstName varchar(100),\r\nLastName varchar(100),\r\nCity varchar(100),\r\n<b> <span class=\"tooltip\">PRIMARY KEY<\/span>(UserID)<\/b>\r\n); <\/span><\/span><\/pre>\n<p>&nbsp;<\/p>\n<h4><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">NOT NULL : <\/span><\/span><\/h4>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">Bir s\u00fctunun NULL de\u011feri i\u00e7eremedi\u011fini g\u00f6sterir.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">UNIQUE &#8211; <\/span><\/span><\/h4>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">Bir s\u00fctuna yinelenen bir de\u011fer eklenmesine izin vermmemek i\u00e7in kullan\u0131l\u0131r.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<h4><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">CHECK &#8211; <\/span><\/span><\/h4>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">Girilen de\u011ferin tan\u0131mlanan veri tipi i\u00e7in uygun olup olmad\u0131\u011f\u0131n\u0131 belirler.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<h4>AUTO INCREMENT &#8211;<\/h4>\n<p>AUTO INCREMENT, <span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">tabloya yeni bir kay\u0131t eklendi\u011finde benzersiz bir say\u0131 olu\u015fturulmas\u0131na izin verir. Genellikle, <strong>primary key<\/strong> alan\u0131na,\u00a0 her yeni kay\u0131t eklendi\u011finde otomatik olarak yeni bir say\u0131 (benzersiz ve s\u0131radaki say\u0131) olu\u015fturulmas\u0131n\u0131 sa\u011flar.<br \/>\n<\/span><\/span><\/p>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">Varsay\u0131lan olarak, AUTO_INCREMENT i\u00e7in ba\u015flang\u0131\u00e7 de\u011feri 1&#8217;dir ve her yeni kay\u0131t i\u00e7in 1 artmaktad\u0131r.<\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>Hepsinin \u00f6rnek kullan\u0131mlar\u0131na bir bakal\u0131m ,<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><span class=\"tooltip\">CREATE TABLE<\/span> Users (\r\nid int <b>NOT <span class=\"tooltip\">NULL<\/span> <span class=\"tooltip\">AUTO_INCREMENT<\/span><\/b>,\r\nusername varchar(40) <b>NOT <span class=\"tooltip\">NULL<\/span><\/b>,\r\npassword varchar(10) <b>NOT <span class=\"tooltip\">NULL<\/span><\/b>,\r\n<b><span class=\"tooltip\">PRIMARY KEY<\/span>(id)<\/b>\r\n);<\/span><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10258\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_2.png\" alt=\"\" width=\"922\" height=\"586\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_2.png 615w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_2-300x191.png 300w\" sizes=\"auto, (max-width: 922px) 100vw, 922px\" \/><\/p>\n<p>Bu yaz\u0131l\u0131k bu kadar, bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba SQL Yaz\u0131lar\u0131na devam ediyoruz, bu yaz\u0131da tablo olu\u015fturma i\u015flemlerine bakaca\u011f\u0131z. Bir \u00f6nceki yaz\u0131m\u0131zda tablodaki verileri g\u00fcncellemeyi ve silmeyi g\u00f6rm\u00fc\u015ft\u00fck bu yaz\u0131ya ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131m\u0131z\u0131 okuman\u0131z\u0131 tavsiye ederiz, ORACLE SQL Dersleri &#8211; Update &nbsp; CREATE TABLE ifadesinin temel kullan\u0131m\u0131 a\u015fa\u011f\u0131daki gibidir : CREATE TABLE table_name ( column_name1 data_type(size), column_name2 data_type(size), column_name3 data_type(size), &#8230;. &hellip;<\/p>\n","protected":false},"author":67,"featured_media":9920,"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":[5487],"tags":[4936,4929,4875,4883,4873,4869,4910,1340,4870,4895,4905,4935,4926,4915,4921,4919,4920,4918,4917,3192,4872,4916,4928,4876,4912,4881,4880,4890,4867,3062,4879,4891,4923,4924,4922,4925,4909,4911,4877,4896,4908,4882,4884,4897,4901,4900,4898,4902,4903,4899,4871,3015,3018,4868,4904,4906,4893,4930,4934,4914,4933,4885,4887,4913,3000,4931,4889,4927,4907,4888,4886,4892,4874,4878,4894,4932],"class_list":["post-10253","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql-turkce","tag-case-insensetive","tag-create-view","tag-database-nedir","tag-insert-nedir","tag-kolay-sql","tag-mysql-sql","tag-or","tag-oracle-sql","tag-php-sql","tag-plsql","tag-right-outer-join","tag-selecting-multiple-colum","tag-sql-all-drop","tag-sql-all-statements","tag-sql-alter","tag-sql-alter-colum","tag-sql-alter-database","tag-sql-alter-statement","tag-sql-alter-table","tag-sql-and","tag-sql-baslangic-dersleri","tag-sql-creat-table","tag-sql-create-view","tag-sql-database","tag-sql-date-functions","tag-sql-dcl","tag-sql-ddl","tag-sql-delete","tag-sql-dersleri","tag-sql-distinct","tag-sql-dml","tag-sql-dml-nedir","tag-sql-drop-colum","tag-sql-drop-database","tag-sql-drop-statement","tag-sql-drop-table","tag-sql-filtering-data","tag-sql-functions","tag-sql-ifadeleri","tag-sql-ile-ne-yapilir","tag-sql-in-statement","tag-sql-insert","tag-sql-insert-nasil-yapilir","tag-sql-is-ilanlari","tag-sql-join-yapisi","tag-sql-kaynaklari","tag-sql-kullanmak","tag-sql-lef-join","tag-sql-left-outer-join","tag-sql-makaleleri","tag-sql-nasil-ogrenilir","tag-sql-nedir","tag-sql-ogrenme","tag-sql-ogrenmek","tag-sql-right-join","tag-sql-right-outer-join","tag-sql-select-islemi","tag-sql-set-auto-increment","tag-sql-sorting-results","tag-sql-subqueries","tag-sql-syntaxt-rule","tag-sql-tablo-olusturma","tag-sql-tablo-yapisi","tag-sql-to_char-function","tag-sql-tutorial","tag-sql-union-statement","tag-sql-update-islemi","tag-sql-view","tag-sql-where-statement","tag-sql-yapisi","tag-tablo-nedr","tag-tablodan-veri-cekmek","tag-temel-seviye-sql","tag-temel-seviyede-sql","tag-tsql","tag-union-table"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/06\/sql-express.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10253","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=10253"}],"version-history":[{"count":2,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10253\/revisions"}],"predecessor-version":[{"id":10260,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10253\/revisions\/10260"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/9920"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=10253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}