{"id":10232,"date":"2019-07-01T10:38:58","date_gmt":"2019-07-01T10:38:58","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10232"},"modified":"2019-07-24T08:27:18","modified_gmt":"2019-07-24T08:27:18","slug":"oracle-sql-dersleri-update","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-dersleri-update\/","title":{"rendered":"ORACLE SQL Dersleri &#8211; Update"},"content":{"rendered":"<p>Merhabalar SQL yaz\u0131lar\u0131na devam ediyoruz, bir \u00f6nceki yaz\u0131m\u0131zda INSERT ifadelerini i\u015flemi\u015ftik bu yaz\u0131m\u0131zda da UPDATE ve DELETE ifadelerine bakaca\u011f\u0131z.<\/p>\n<p>Bir \u00f6nceki yaz\u0131m\u0131z\u0131 okumad\u0131ysan\u0131z buradan okuman\u0131z\u0131 tavsiye ederiz,<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"vMW0Q9BgLu\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-dersleri-insert-data\/\">ORACLE SQL Dersleri &#8211; INSERT DATA<\/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; INSERT DATA&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-dersleri-insert-data\/embed\/#?secret=8hBzKxR60W#?secret=vMW0Q9BgLu\" data-secret=\"vMW0Q9BgLu\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2>UPDATE :<\/h2>\n<p>UPDATE s\u00f6zc\u00fc\u011f\u00fcn\u00fc tablomuzda veri veya verilerimizi yeni bir veriyle de\u011fi\u015ftirmek i\u00e7in kullan\u0131r\u0131z. \u00d6rnek yaz\u0131m kural\u0131 \u015fu \u015fekilde ,<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">UPDATE<\/span> <\/b>tablo_ismi\r\n<b>SET <\/b>kolon1=de\u011fer1, kolon2=de\u011fer2, ...\r\n<span class=\"tooltip\">WHERE<\/span> condition;<\/span><\/span><\/pre>\n<ul>\n<li><strong>E\u011fer update i\u015flemi yaparken <span style=\"color: #ff0000\">where <span style=\"color: #000000\">ko\u015fulu koyulmazsa b\u00fct\u00fcn tablo i\u00e7in g\u00fcncelleme yapar bu da istemedi\u011fimiz bir durumdur.<\/span><\/span><\/strong><\/li>\n<\/ul>\n<p>Bir \u00f6rnek \u00fczerinden ilerleyelim,<\/p>\n<pre>select * from employees where salary&gt;15000;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10246\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_22.png\" alt=\"\" width=\"982\" height=\"265\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_22.png 982w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_22-300x81.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_22-768x207.png 768w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/p>\n<p><strong>salary <\/strong>alan\u0131 15000&#8217;den b\u00fcy\u00fck sonu\u00e7lar\u0131 listeledik ve 3 tane oldu\u011funu g\u00f6rd\u00fck . \u015eimdi employee_id de\u011feri 102 olan kayd\u0131m\u0131z\u0131n salary de\u011ferini 20000 ile de\u011fi\u015ftirelim.<\/p>\n<pre>update hr.employees set salary=20000 where employee_id=102;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10248\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_23.png\" alt=\"\" width=\"991\" height=\"181\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_23.png 991w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_23-300x55.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_23-768x140.png 768w\" sizes=\"auto, (max-width: 991px) 100vw, 991px\" \/><\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc gibi <strong>employee_id&#8217;<\/strong>si 102 olan kayd\u0131m\u0131z\u0131n yeni <strong>salary<\/strong> de\u011feri 20000 olmu\u015f durumda.<\/p>\n<p>Bir \u00f6rnek&#8217;te birden fazla de\u011fer i\u00e7in g\u00fcncelleme yapal\u0131m,<\/p>\n<pre>update hr.employees set salary=30000, first_name='Kemal' where employee_id=102;<\/pre>\n<p>102 id numaral\u0131 kayd\u0131n (Lex) <strong>first_name<\/strong> de\u011ferini Kemal ve <strong>salary<\/strong> de\u011ferini 30000 yapt\u0131.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10249\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_24.png\" alt=\"\" width=\"983\" height=\"233\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_24.png 983w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_24-300x71.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_24-768x182.png 768w\" sizes=\"auto, (max-width: 983px) 100vw, 983px\" \/><\/p>\n<h1>Deleting Data:<\/h1>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span class=\"\" title=\"\">DELETE ifadesi, tablonuzdaki verileri silmek i\u00e7in kullan\u0131l\u0131r.<\/span> <span class=\"\" title=\"\">DELETE sorgular\u0131, UPDATE sorgular\u0131na benzer \u015fekilde yaz\u0131l\u0131r.<\/span><\/span><\/p>\n<p>\u00d6rnek yaz\u0131m \u015fekli \u015fu \u015fekildedir,<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><span class=\"tooltip\">DELETE <\/span>FROM table_name\r\n<span class=\"tooltip\">WHERE<\/span> condition; <\/span><\/span><\/pre>\n<p>Bir \u00f6rnek yapal\u0131m, yukar\u0131da HR.JOBS tablomuzda J_DEV id nolu kayd\u0131n oldu\u011funu biliyoruz. Bu kayd\u0131 silelim ve ard\u0131ndan sorgulamaya \u00e7al\u0131\u015fal\u0131m.<\/p>\n<pre>delete from hr.jobs where job_id='J_DEV'<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-10250\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_25.png\" alt=\"\" width=\"727\" height=\"342\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_25.png 538w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/Screenshot_25-300x141.png 300w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>E\u011fer tabloyu k\u00f6kten yok etmek istiyorsan\u0131z,<\/p>\n<pre>drop table hr.jobs;<\/pre>\n<p>yazman\u0131z yeterli \ud83d\ude42<\/p>\n<p>&nbsp;<\/p>\n<p>Bir sonraki yaz\u0131da g\u00f6r\u00fc\u015fmek \u00fczere, ho\u015f\u00e7akal\u0131n..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar SQL yaz\u0131lar\u0131na devam ediyoruz, bir \u00f6nceki yaz\u0131m\u0131zda INSERT ifadelerini i\u015flemi\u015ftik bu yaz\u0131m\u0131zda da UPDATE ve DELETE ifadelerine bakaca\u011f\u0131z. Bir \u00f6nceki yaz\u0131m\u0131z\u0131 okumad\u0131ysan\u0131z buradan okuman\u0131z\u0131 tavsiye ederiz, ORACLE SQL Dersleri &#8211; INSERT DATA &nbsp; &nbsp; UPDATE : UPDATE s\u00f6zc\u00fc\u011f\u00fcn\u00fc tablomuzda veri veya verilerimizi yeni bir veriyle de\u011fi\u015ftirmek i\u00e7in kullan\u0131r\u0131z. \u00d6rnek yaz\u0131m kural\u0131 \u015fu \u015fekilde , &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-10232","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\/10232","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=10232"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10232\/revisions"}],"predecessor-version":[{"id":10251,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10232\/revisions\/10251"}],"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=10232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}