{"id":16143,"date":"2020-05-24T15:21:56","date_gmt":"2020-05-24T15:21:56","guid":{"rendered":"https:\/\/ittutorial.org\/?p=16143"},"modified":"2020-05-24T15:21:56","modified_gmt":"2020-05-24T15:21:56","slug":"delete-statement-delete-from-in-oracle-sql-oracle-sql-tutorials-11","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/delete-statement-delete-from-in-oracle-sql-oracle-sql-tutorials-11\/","title":{"rendered":"DELETE Statement in Oracle SQL | Oracle SQL Tutorials -11"},"content":{"rendered":"<p align=\"left\">Hi,<\/p>\n<p align=\"left\">I will explain DELETE Statement in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n<p align=\"left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16079\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png\" alt=\"\" width=\"387\" height=\"311\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial.png 387w, https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/05\/oracle-sql-tutorial-300x241.png 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/><\/p>\n<p align=\"left\"><!--more--><\/p>\n<p align=\"left\">\n<p align=\"left\">\n<p align=\"left\"><span style=\"color: #ff0000;\"><strong>Read the previous post of this tutorial series before this.<\/strong><\/span><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"revA3HTWE3\"><p><a href=\"https:\/\/ittutorial.org\/update-statement-in-oracle-sql-oracle-sql-tutorials-10\/\">UPDATE Statement in Oracle SQL | Oracle SQL Tutorials -10<\/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;UPDATE Statement in Oracle SQL | Oracle SQL Tutorials -10&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/update-statement-in-oracle-sql-oracle-sql-tutorials-10\/embed\/#?secret=OsknwxSOn9#?secret=revA3HTWE3\" data-secret=\"revA3HTWE3\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p align=\"left\">\n<p align=\"left\">\n<p align=\"left\">The Delete statement is popular command of Oracle SQL and You can delete any existing record in a table using Delete Statement.<\/p>\n<p align=\"left\">\n<p><span style=\"color: #ff0000;\"><strong>DELETE Syntax<\/strong><\/span><\/p>\n<p>Delete statement syntax is as follows.<\/p>\n<h3><\/h3>\n<div class=\"w3-example\">\n<div class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">DELETE<\/span>\u00a0<span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name\u00a0<\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/div>\n<\/div>\n<div><\/div>\n<div><\/div>\n<div>Delete employee that employee id is 100<\/div>\n<pre>SQL&gt; select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where EMPLOYEE_ID=100;\r\n\r\nEMPLOYEE_ID FIRST_NAME           LAST_NAME                     SALARY\r\n----------- -------------------- ------------------------- ----------\r\n        100 MEHMET SALIH         DEVECI                         30000\r\n\r\n\r\nSQL&gt; delete from hr.employees where EMPLOYEE_ID=100;\r\n\r\n1 row deleted.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.\r\n\r\nSQL&gt; select EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY from hr.employees where EMPLOYEE_ID=100;\r\n\r\nno rows selected\r\n\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>Delete All Records<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<pre>SQL&gt; select * from hr.departments;\r\n\r\nDEPARTMENT_ID DEPARTMENT_NAME                MANAGER_ID LOCATION_ID\r\n------------- ------------------------------ ---------- -----------\r\n           10 Administration                        200        1700\r\n           20 Marketing                             201        1800\r\n           30 Purchasing                            114        1700\r\n           40 Human Resources                       203        2400\r\n           50 Shipping                              121        1500\r\n           60 IT                                    103        1400\r\n           70 Public Relations                      204        2700\r\n           80 Sales                                 145        2500\r\n           90 Executive                             100        1700\r\n          100 Finance                               108        1700\r\n          110 Accounting                            205        1700\r\n\r\nDEPARTMENT_ID DEPARTMENT_NAME                MANAGER_ID LOCATION_ID\r\n------------- ------------------------------ ---------- -----------\r\n          120 Treasury                                         1700\r\n          130 Corporate Tax                                    1700\r\n          140 Control And Credit                               1700\r\n          150 Shareholder Services                             1700\r\n          160 Benefits                                         1700\r\n          170 Manufacturing                                    1700\r\n          180 Construction                                     1700\r\n          190 Contracting                                      1700\r\n          200 Operations                                       1700\r\n          210 IT Support                                       1700\r\n          220 NOC                                              1700\r\n\r\nDEPARTMENT_ID DEPARTMENT_NAME                MANAGER_ID LOCATION_ID\r\n------------- ------------------------------ ---------- -----------\r\n          230 IT Helpdesk                                      1700\r\n          240 Government Sales                                 1700\r\n          250 Retail Sales                                     1700\r\n          260 Recruiting                                       1700\r\n          270 Payroll                                          1700\r\n           11 Computer Engineering                  201        1700\r\n         2010 IT TUTORIAL\r\n\r\n29 rows selected.\r\n\r\nSQL&gt; \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<strong><span style=\"color: #ff0000;\">SQL&gt; delete from hr.departments;<\/span><\/strong>\r\n\r\n29 rows deleted.\r\n\r\nSQL&gt; commit; \r\n\r\nCommit complete.\r\n\r\n\r\nSQL&gt; select * from hr.departments;\r\n\r\nno rows selected\r\n\r\nSQL&gt; \r\n\r\n\r\n\r\n\r\n<\/pre>\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=\"OViF7OR6Dn\"><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=\"&#8220;Oracle Tutorial | Oracle Database Tutorials for Beginners  ( Junior Oracle DBA )&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=CrxmG0uk4s#?secret=OViF7OR6Dn\" data-secret=\"OViF7OR6Dn\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will explain DELETE 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":[11497,11495,11494,11502,11496,11498,11506,9037,11503,11505,11501,11500,11499,11504,11351,11304,3001,11302,3013,2673,11301,3715,11493,11492,11491,11490],"class_list":["post-16143","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-delete-all-rows-from-table-oracle","tag-delete-all-rows-from-table-sql","tag-delete-column-in-sql","tag-delete-oracle-plsql","tag-delete-query-in-oracle","tag-delete-statement-in-oracle-sql","tag-delete-from-table_name","tag-oracle-dba-tutorial","tag-oracle-delete-cascade","tag-oracle-delete-cascade-child-records","tag-oracle-delete-from-select","tag-oracle-delete-from-multiple-tables","tag-oracle-delete-with-join","tag-oracle-delete-without-from","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-sql-tutorials","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-sql-delete-from-multiple-tables","tag-sql-delete-from-select","tag-sql-delete-multiple-rows","tag-sql-delete-join"],"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\/16143","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=16143"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16143\/revisions"}],"predecessor-version":[{"id":16145,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16143\/revisions\/16145"}],"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=16143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}