{"id":10278,"date":"2019-07-03T10:42:09","date_gmt":"2019-07-03T10:42:09","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10278"},"modified":"2019-07-24T08:26:05","modified_gmt":"2019-07-24T08:26:05","slug":"oracle-sql-dersleri-alterdroprename","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-dersleri-alterdroprename\/","title":{"rendered":"ORACLE SQL Dersleri &#8211; Alter,Drop,Rename"},"content":{"rendered":"<p>Merhaba, SQL yaz\u0131lar\u0131na devam ediyoruz. Bir \u00f6nceki yaz\u0131da tablo olu\u015fturmay\u0131 ve k\u0131s\u0131tlamalara bakm\u0131\u015ft\u0131k, bu yaz\u0131m\u0131zda <strong>alter, drop <\/strong>gibi i\u015flemlere bakaca\u011f\u0131z. Bu yaz\u0131m\u0131za ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131ya g\u00f6z atman\u0131zda fayda var.<\/p>\n<p>&nbsp;<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"UUg6KCOEit\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-dersleri-creating-a-table\/\">ORACLE SQL Dersleri &#8211; Creating a Table<\/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; Creating a Table&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-dersleri-creating-a-table\/embed\/#?secret=zNvQWEMEHC#?secret=UUg6KCOEit\" data-secret=\"UUg6KCOEit\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h1>ALTER TABLE :<\/h1>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\"><span style=\"color: #ff0000\">ALTER TABLE<\/span> komutu, mevcut bir tablodaki s\u00fctunlar\u0131 eklemek, silmek veya de\u011fi\u015ftirmek i\u00e7in kullan\u0131l\u0131r.<\/span><\/span><\/p>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">Ayr\u0131ca mevcut bir tabloya \u00e7e\u015fitli k\u0131s\u0131tlamalar(constrait) eklemek ve \u00e7\u0131karmak i\u00e7in ALTER TABLE komutunu kullan\u0131rs\u0131n\u0131z.<\/span><\/span><\/p>\n<p>A\u015fa\u011f\u0131daki tabloya bakal\u0131m,<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-10279\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_3.png\" alt=\"\" width=\"749\" height=\"181\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_3.png 596w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_3-300x72.png 300w\" sizes=\"auto, (max-width: 749px) 100vw, 749px\" \/><\/p>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">A\u015fa\u011f\u0131daki SQL kodu, <strong>DateOfBirth<\/strong> adl\u0131 yeni bir s\u00fctun ekler,<br \/>\n<\/span><\/span><\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People<b> ADD<\/b> DateOfBirth date;<\/span><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10280\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_4.png\" alt=\"\" width=\"604\" height=\"152\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_4.png 604w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_4-300x75.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi <strong>DateOfBirth<\/strong> kolonumuz eklenmi\u015f durumda. \u015euan i\u00e7in bu s\u00fctunda veri bulunmuyor ge\u00e7mi\u015f derslerde \u00f6\u011frendi\u011fimiz <strong>update <\/strong>komutu ile bu s\u00fctunlara de\u011fer atayabilirsiniz.<\/p>\n<p>&nbsp;<\/p>\n<h1>Dropping :<\/h1>\n<p>Drop komutumuz ile tablolar\u0131m\u0131z\u0131 prosed\u00fcr, fonksiyon gibi objelerimizi silebiliriz.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People \r\n<b>DROP COLUMN<\/b> DateOfBirth;<\/span><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-10279\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_3.png\" alt=\"\" width=\"857\" height=\"207\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_3.png 596w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_3-300x72.png 300w\" sizes=\"auto, (max-width: 857px) 100vw, 857px\" \/><\/p>\n<p>Kolonu silmi\u015f olduk, istersek tobloyu komple silebiliriz.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">DROP TABLE<\/span><\/b> People;<\/span><\/span><\/pre>\n<p>&nbsp;<\/p>\n<h1>Renaming :<\/h1>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">ALTER TABLE komutunun bir di\u011fer \u00f6zelli\u011fi, s\u00fctunlar\u0131 yeniden adland\u0131rmak i\u00e7in de kullan\u0131l\u0131r, \u00f6rnek bir kullan\u0131m\u0131 \u015fu \u015fekilde.<br \/>\n<\/span><\/span><\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><span class=\"tooltip\">ALTER TABLE<\/span> People\r\nCHANGE FirstName name varchar(100);<\/span><\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-10281\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_5.png\" alt=\"\" width=\"872\" height=\"208\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_5.png 608w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_5-300x72.png 300w\" sizes=\"auto, (max-width: 872px) 100vw, 872px\" \/><\/p>\n<p>Resimde g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi daha \u00f6nceden FirstName olan kolonun ismi, \u015fuanda <strong>name<\/strong>\u00a0 olarak de\u011fi\u015ftirildi.<\/p>\n<p>&nbsp;<\/p>\n<p>E\u011fer bir tablonun ismini de\u011fi\u015ftirmek istersek, \u015fu komutla tek seferde de\u011fi\u015ftirebiliriz;<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b>RENAME TABLE<\/b> People <b>TO <\/b>Users;<\/span><\/span><\/pre>\n<p>Bu komut <strong>People<\/strong> tablosunu <strong>Users<\/strong> olarak de\u011fi\u015ftirir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba, SQL yaz\u0131lar\u0131na devam ediyoruz. Bir \u00f6nceki yaz\u0131da tablo olu\u015fturmay\u0131 ve k\u0131s\u0131tlamalara bakm\u0131\u015ft\u0131k, bu yaz\u0131m\u0131zda alter, drop gibi i\u015flemlere bakaca\u011f\u0131z. Bu yaz\u0131m\u0131za ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131ya g\u00f6z atman\u0131zda fayda var. &nbsp; ORACLE SQL Dersleri &#8211; Creating a Table &nbsp; ALTER TABLE : ALTER TABLE komutu, mevcut bir tablodaki s\u00fctunlar\u0131 eklemek, silmek veya de\u011fi\u015ftirmek i\u00e7in &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-10278","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\/10278","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=10278"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10278\/revisions"}],"predecessor-version":[{"id":10282,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10278\/revisions\/10282"}],"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=10278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}