{"id":10153,"date":"2019-07-01T08:53:38","date_gmt":"2019-07-01T08:53:38","guid":{"rendered":"https:\/\/ittutorial.org\/?p=10153"},"modified":"2019-07-24T08:27:42","modified_gmt":"2019-07-24T08:27:42","slug":"oracle-sql-dersleri-insert-data","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-dersleri-insert-data\/","title":{"rendered":"ORACLE SQL Dersleri &#8211; INSERT DATA"},"content":{"rendered":"<p>Merhaba Oracle SQL derslerine devam ediyoruz, bir \u00f6nceki yaz\u0131m\u0131zda JOIN konusuna bakm\u0131\u015ft\u0131k bu yaz\u0131m\u0131zda ve devam\u0131nda art\u0131k DML konular\u0131na bakaca\u011f\u0131z. Bu yaz\u0131m\u0131za ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131ya buradan ula\u015fabilirsiniz,<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"IRasnJCksP\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-join-table\/\">ORACLE SQL &#8211; Join 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 &#8211; Join Table&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-join-table\/embed\/#?secret=OgXYiXb0nG#?secret=IRasnJCksP\" data-secret=\"IRasnJCksP\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h1>Inserting Data<\/h1>\n<p>&nbsp;<\/p>\n<p><span class=\"tlid-translation translation\" lang=\"tr\"><span title=\"\">Veritaban\u0131, tablolar\u0131n i\u00e7indeki verileri sat\u0131rlar halinde, birbiri ard\u0131na depolar.<\/span> <span class=\"\" title=\"\"><strong>INSERT INTO<\/strong> s\u00f6zc\u00fc\u011f\u00fc, veritaban\u0131ndaki bir tabloya yeni veri sat\u0131rlar\u0131 eklemek i\u00e7in kullan\u0131l\u0131r.<br \/>\n<\/span><\/span><\/p>\n<p>Yaz\u0131m kural\u0131 \u015fu \u015fekildedir,<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">INSERT INTO<\/span><\/b> table_name\n<b>VALUES <\/b>(value1, value2, value3,...);<\/span><\/span><\/pre>\n<p>&nbsp;<\/p>\n<p>A\u015fa\u011f\u0131daki \u00f6rnekte JOBS tablosuna bir \u00f6nceden olmayan bir kay\u0131t ekledik ve daha sonra kontrol ettik.<\/p>\n<pre>select * from hr.jobs;\n\ninsert into hr.jobs values('crm_mng', 'CRM MANAGER', 17000,25000);\n\nselect * from hr.jobs where job_title='CRM MANAGER';<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10154\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/insert_gif.gif\" alt=\"\" width=\"883\" height=\"595\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u0130stersek t\u00fcm kolonlara de\u011fer girmeden istedi\u011fimiz kolona da kay\u0131t ekleyebiliriz(Ancak kolonlar i\u00e7in bo\u015f ge\u00e7ilemez kural\u0131 tan\u0131mlanmad\u0131ysa).<\/p>\n<p>Bu durumda yaz\u0131m kural\u0131 \u015fu \u015fekilde oluyor,<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><span class=\"tooltip\">INSERT INTO<\/span> table_name<b> (column1, column2, column3, ...,columnN) <\/b>\nVALUES (value1, value2, value3,...valueN);<\/span><\/span><\/pre>\n<p>&nbsp;<\/p>\n<pre>select * from hr.jobs where job_title='Java Developer';<\/pre>\n<pre>insert into hr.jobs (job_id,job_title) values('J_DEV','Java Developer');<\/pre>\n<pre>select * from hr.jobs where job_title='Java Developer';<\/pre>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10156\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/07\/insert_1.gif\" alt=\"\" width=\"845\" height=\"570\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>INSERT<\/strong> i\u015fleminin genel mant\u0131\u011f\u0131 bu \u015fekilde detayl\u0131 \u00f6rneklerini payla\u015faca\u011f\u0131m\u0131z uygulama-2 yaz\u0131m\u0131zdan g\u00f6rebilirsiniz.<\/p>\n<p>G\u00f6r\u00fc\u015fmek \u00fczere..<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhaba Oracle SQL derslerine devam ediyoruz, bir \u00f6nceki yaz\u0131m\u0131zda JOIN konusuna bakm\u0131\u015ft\u0131k bu yaz\u0131m\u0131zda ve devam\u0131nda art\u0131k DML konular\u0131na bakaca\u011f\u0131z. Bu yaz\u0131m\u0131za ge\u00e7meden \u00f6nce bir \u00f6nceki yaz\u0131ya buradan ula\u015fabilirsiniz, ORACLE SQL &#8211; Join Table &nbsp; Inserting Data &nbsp; Veritaban\u0131, tablolar\u0131n i\u00e7indeki verileri sat\u0131rlar halinde, birbiri ard\u0131na depolar. INSERT INTO s\u00f6zc\u00fc\u011f\u00fc, veritaban\u0131ndaki bir tabloya yeni veri &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-10153","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\/10153","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=10153"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10153\/revisions"}],"predecessor-version":[{"id":10231,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/10153\/revisions\/10231"}],"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=10153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=10153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=10153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}