Hi,<\/p>\n
I will explain UPDATE Statement in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n
<\/p>\n
\n
Read the previous post of this tutorial series before this.<\/strong><\/span><\/p>\nNULL Values And Is Null or Is Not Null in Oracle SQL | Oracle SQL Tutorials -9<\/a><\/p><\/blockquote>\n<\/iframe><\/p>\n<p align=\"left\">\n<p align=\"left\">The UPDATE statement is popular command of Oracle SQL and You can modify any existing record in a table using Update Statement.<\/p>\n<p align=\"left\">\n<p><span style=\"color: #ff0000;\"><strong>UPDATE Syntax<\/strong><\/span><\/p>\n<p>Update statement syntax is as follows.<\/p>\n<p> <\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span>\u00a0<em>column1\u00a0<\/em>=<em> value1 <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span>\u00a0<em>column1\u00a0<\/em>=<em>\u00a0value1<\/em>,<em>\u00a0column2\u00a0<\/em>=<em>\u00a0value2<\/em>, … <span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/p>\n<div class=\"w3-example\">\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span><em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span><em>column1\u00a0<\/em>=<em>\u00a0value1<\/em>,<em>\u00a0column2\u00a0<\/em>=<em>\u00a0value2<\/em>, … <span class=\"sqlkeywordcolor\">WHERE<\/span><em>condition<\/em>;<\/span><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Update employee’s First name and Last Name column which EMPLOYEE_ID=100 as follows<\/div>\n<div><\/div>\n<div>\n<pre>SQL> update hr.employees set FIRST_NAME='MEHMET SALIH', LAST_NAME='DEVECI' where EMPLOYEE_ID=100;\r\n\r\n1 row updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> \r\n\r\nSQL> \r\nSQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME from hr.employees where EMPLOYEE_ID=100;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME\r\n----------- -------------------- -------------------------\r\n 100 MEHMET SALIH DEVECI\r\n\r\nSQL><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>You can update multiple records in a Update statement as follows.<\/div>\n<div><\/div>\n<div>Let’s raise salary of employees that salary is greater than 15000 as follows.<\/div>\n<div><\/div>\n<div>\n<pre>SQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where salary>15000;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME SALARY\r\n----------- -------------------- ------------------------- ----------\r\n 100 MEHMET SALIH DEVECI 24000\r\n 101 Neena Kochhar 17000\r\n 102 Lex De Haan 17000\r\n\r\nSQL> \r\nSQL> update hr.employees set salary=salary+5000 where salary>15000;\r\n\r\n3 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> \r\nSQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where salary>15000;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME SALARY\r\n----------- -------------------- ------------------------- ----------\r\n 100 MEHMET SALIH DEVECI 29000\r\n 101 Neena Kochhar 22000\r\n 102 Lex De Haan 22000\r\n\r\nSQL><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Or update employees’ commission_pct as 0.5 if commission_pct\u00a0 are null.<\/div>\n<div><\/div>\n<div>\n<pre>SQL> update hr.employees set commission_pct=0.5 where commission_pct is null;\r\n\r\n72 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL><\/pre>\n<\/div>\n<p> <\/p>\n<p>If you don’t use or forget to use WHERE clause, ALL records will be updated! So be carefull during update.<\/p>\n<p> <\/p>\n\n<p> <\/p>\n<p> <\/p>\n<p>For Example, I don’t use or forget to use Where clause, then All employees’ salary raised by 1000 $ \ud83d\ude42<\/p>\n<div class=\"w3-example\"><\/div>\n<pre>SQL> update hr.employees set SALARY=SALARY+1000;\r\n\r\n107 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"8IkfjHe9DO\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/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=\"“Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=Rk3jY7EJYK#?secret=8IkfjHe9DO\" data-secret=\"8IkfjHe9DO\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain UPDATE Statement in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"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":[3019],"tags":[11467,11478,11469,9037,11351,11304,3001,11302,11471,2673,11301,11475,11472,3715,11474,11466,11465,11464,11468,11476,11477,11473,11462,11463,11470],"class_list":["post-16118","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-delete-sql","tag-how-to-update-multiple-rows-in-oracle","tag-insert-sql","tag-oracle-dba-tutorial","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-sql-update-multiple-columns","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-oracle-update-multiple-columns-from-another-table","tag-oracle-update-statement-with-join","tag-pl-sql-tutorial","tag-select-and-update-in-one-query-oracle","tag-sql-update-from-another-table","tag-sql-update-multiple-columns","tag-sql-update-multiple-rows","tag-sql-update-multiple-rows-with-different-values","tag-update-oracle-sql-developer","tag-update-query-in-oracle","tag-update-query-in-oracle-using-two-tables","tag-update-sql-oracle","tag-update-sql-with-join","tag-update-statement-in-oracle-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16118"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118\/revisions"}],"predecessor-version":[{"id":16119,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118\/revisions\/16119"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
NULL Values And Is Null or Is Not Null in Oracle SQL | Oracle SQL Tutorials -9<\/a><\/p><\/blockquote>\n<\/iframe><\/p>\n<p align=\"left\">\n<p align=\"left\">The UPDATE statement is popular command of Oracle SQL and You can modify any existing record in a table using Update Statement.<\/p>\n<p align=\"left\">\n<p><span style=\"color: #ff0000;\"><strong>UPDATE Syntax<\/strong><\/span><\/p>\n<p>Update statement syntax is as follows.<\/p>\n<p> <\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span>\u00a0<em>column1\u00a0<\/em>=<em> value1 <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span>\u00a0<em>column1\u00a0<\/em>=<em>\u00a0value1<\/em>,<em>\u00a0column2\u00a0<\/em>=<em>\u00a0value2<\/em>, … <span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/p>\n<div class=\"w3-example\">\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span><em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span><em>column1\u00a0<\/em>=<em>\u00a0value1<\/em>,<em>\u00a0column2\u00a0<\/em>=<em>\u00a0value2<\/em>, … <span class=\"sqlkeywordcolor\">WHERE<\/span><em>condition<\/em>;<\/span><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Update employee’s First name and Last Name column which EMPLOYEE_ID=100 as follows<\/div>\n<div><\/div>\n<div>\n<pre>SQL> update hr.employees set FIRST_NAME='MEHMET SALIH', LAST_NAME='DEVECI' where EMPLOYEE_ID=100;\r\n\r\n1 row updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> \r\n\r\nSQL> \r\nSQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME from hr.employees where EMPLOYEE_ID=100;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME\r\n----------- -------------------- -------------------------\r\n 100 MEHMET SALIH DEVECI\r\n\r\nSQL><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>You can update multiple records in a Update statement as follows.<\/div>\n<div><\/div>\n<div>Let’s raise salary of employees that salary is greater than 15000 as follows.<\/div>\n<div><\/div>\n<div>\n<pre>SQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where salary>15000;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME SALARY\r\n----------- -------------------- ------------------------- ----------\r\n 100 MEHMET SALIH DEVECI 24000\r\n 101 Neena Kochhar 17000\r\n 102 Lex De Haan 17000\r\n\r\nSQL> \r\nSQL> update hr.employees set salary=salary+5000 where salary>15000;\r\n\r\n3 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> \r\nSQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where salary>15000;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME SALARY\r\n----------- -------------------- ------------------------- ----------\r\n 100 MEHMET SALIH DEVECI 29000\r\n 101 Neena Kochhar 22000\r\n 102 Lex De Haan 22000\r\n\r\nSQL><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Or update employees’ commission_pct as 0.5 if commission_pct\u00a0 are null.<\/div>\n<div><\/div>\n<div>\n<pre>SQL> update hr.employees set commission_pct=0.5 where commission_pct is null;\r\n\r\n72 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL><\/pre>\n<\/div>\n<p> <\/p>\n<p>If you don’t use or forget to use WHERE clause, ALL records will be updated! So be carefull during update.<\/p>\n<p> <\/p>\n\n<p> <\/p>\n<p> <\/p>\n<p>For Example, I don’t use or forget to use Where clause, then All employees’ salary raised by 1000 $ \ud83d\ude42<\/p>\n<div class=\"w3-example\"><\/div>\n<pre>SQL> update hr.employees set SALARY=SALARY+1000;\r\n\r\n107 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"8IkfjHe9DO\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/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=\"“Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=Rk3jY7EJYK#?secret=8IkfjHe9DO\" data-secret=\"8IkfjHe9DO\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain UPDATE Statement in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"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":[3019],"tags":[11467,11478,11469,9037,11351,11304,3001,11302,11471,2673,11301,11475,11472,3715,11474,11466,11465,11464,11468,11476,11477,11473,11462,11463,11470],"class_list":["post-16118","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-delete-sql","tag-how-to-update-multiple-rows-in-oracle","tag-insert-sql","tag-oracle-dba-tutorial","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-sql-update-multiple-columns","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-oracle-update-multiple-columns-from-another-table","tag-oracle-update-statement-with-join","tag-pl-sql-tutorial","tag-select-and-update-in-one-query-oracle","tag-sql-update-from-another-table","tag-sql-update-multiple-columns","tag-sql-update-multiple-rows","tag-sql-update-multiple-rows-with-different-values","tag-update-oracle-sql-developer","tag-update-query-in-oracle","tag-update-query-in-oracle-using-two-tables","tag-update-sql-oracle","tag-update-sql-with-join","tag-update-statement-in-oracle-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16118"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118\/revisions"}],"predecessor-version":[{"id":16119,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118\/revisions\/16119"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/iframe><\/p>\n<p align=\"left\">\n<p align=\"left\">The UPDATE statement is popular command of Oracle SQL and You can modify any existing record in a table using Update Statement.<\/p>\n<p align=\"left\">\n<p><span style=\"color: #ff0000;\"><strong>UPDATE Syntax<\/strong><\/span><\/p>\n<p>Update statement syntax is as follows.<\/p>\n<p> <\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span>\u00a0<em>column1\u00a0<\/em>=<em> value1 <\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/p>\n<p><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span>\u00a0<em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span>\u00a0<em>column1\u00a0<\/em>=<em>\u00a0value1<\/em>,<em>\u00a0column2\u00a0<\/em>=<em>\u00a0value2<\/em>, … <span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/p>\n<div class=\"w3-example\">\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span><em>table_name <\/em><span class=\"sqlkeywordcolor\">SET<\/span><em>column1\u00a0<\/em>=<em>\u00a0value1<\/em>,<em>\u00a0column2\u00a0<\/em>=<em>\u00a0value2<\/em>, … <span class=\"sqlkeywordcolor\">WHERE<\/span><em>condition<\/em>;<\/span><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Update employee’s First name and Last Name column which EMPLOYEE_ID=100 as follows<\/div>\n<div><\/div>\n<div>\n<pre>SQL> update hr.employees set FIRST_NAME='MEHMET SALIH', LAST_NAME='DEVECI' where EMPLOYEE_ID=100;\r\n\r\n1 row updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> \r\n\r\nSQL> \r\nSQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME from hr.employees where EMPLOYEE_ID=100;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME\r\n----------- -------------------- -------------------------\r\n 100 MEHMET SALIH DEVECI\r\n\r\nSQL><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>You can update multiple records in a Update statement as follows.<\/div>\n<div><\/div>\n<div>Let’s raise salary of employees that salary is greater than 15000 as follows.<\/div>\n<div><\/div>\n<div>\n<pre>SQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where salary>15000;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME SALARY\r\n----------- -------------------- ------------------------- ----------\r\n 100 MEHMET SALIH DEVECI 24000\r\n 101 Neena Kochhar 17000\r\n 102 Lex De Haan 17000\r\n\r\nSQL> \r\nSQL> update hr.employees set salary=salary+5000 where salary>15000;\r\n\r\n3 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> \r\nSQL> select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where salary>15000;\r\n\r\nEMPLOYEE_ID FIRST_NAME LAST_NAME SALARY\r\n----------- -------------------- ------------------------- ----------\r\n 100 MEHMET SALIH DEVECI 29000\r\n 101 Neena Kochhar 22000\r\n 102 Lex De Haan 22000\r\n\r\nSQL><\/pre>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Or update employees’ commission_pct as 0.5 if commission_pct\u00a0 are null.<\/div>\n<div><\/div>\n<div>\n<pre>SQL> update hr.employees set commission_pct=0.5 where commission_pct is null;\r\n\r\n72 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL><\/pre>\n<\/div>\n<p> <\/p>\n<p>If you don’t use or forget to use WHERE clause, ALL records will be updated! So be carefull during update.<\/p>\n<p> <\/p>\n\n<p> <\/p>\n<p> <\/p>\n<p>For Example, I don’t use or forget to use Where clause, then All employees’ salary raised by 1000 $ \ud83d\ude42<\/p>\n<div class=\"w3-example\"><\/div>\n<pre>SQL> update hr.employees set SALARY=SALARY+1000;\r\n\r\n107 rows updated.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"8IkfjHe9DO\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/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=\"“Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=Rk3jY7EJYK#?secret=8IkfjHe9DO\" data-secret=\"8IkfjHe9DO\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain UPDATE Statement in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n","protected":false},"author":1,"featured_media":16079,"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":[3019],"tags":[11467,11478,11469,9037,11351,11304,3001,11302,11471,2673,11301,11475,11472,3715,11474,11466,11465,11464,11468,11476,11477,11473,11462,11463,11470],"class_list":["post-16118","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-delete-sql","tag-how-to-update-multiple-rows-in-oracle","tag-insert-sql","tag-oracle-dba-tutorial","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-sql-update-multiple-columns","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-oracle-update-multiple-columns-from-another-table","tag-oracle-update-statement-with-join","tag-pl-sql-tutorial","tag-select-and-update-in-one-query-oracle","tag-sql-update-from-another-table","tag-sql-update-multiple-columns","tag-sql-update-multiple-rows","tag-sql-update-multiple-rows-with-different-values","tag-update-oracle-sql-developer","tag-update-query-in-oracle","tag-update-query-in-oracle-using-two-tables","tag-update-sql-oracle","tag-update-sql-with-join","tag-update-statement-in-oracle-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=16118"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118\/revisions"}],"predecessor-version":[{"id":16119,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16118\/revisions\/16119"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/16079"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=16118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png\")
<\/p>\n<\/p>\n