I will explain Alter Table and Alter Table Add or Drop Column in Oracle SQL in this post of Oracle SQL Tutorial series.<\/p>\n
<\/p>\n
Read the previous post of this tutorial series before this.<\/strong><\/span><\/p>\nCreate Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27<\/a><\/p><\/blockquote>\n<\/iframe><\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n\n<p> <\/p>\n<h3><span style=\"color: #ff0000;\">Alter Table<\/span><\/h3>\n<p>You can perform the following tasks using the Alter command.<\/p>\n<ul>\n<li>Rename Table<\/li>\n<li>Add Column<\/li>\n<li>Drop Column<\/li>\n<li>Rename Column<\/li>\n<li>Disable Constraint<\/li>\n<li>Enable Constraint<\/li>\n<li>Add Partition<\/li>\n<li>Drop Partition<\/li>\n<li>Read Only<\/li>\n<li>Read Write<\/li>\n<\/ul>\n<p> <\/p>\n<p>You can add new column as follows.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People<b> ADD<\/b> DateOfBirth date;\r\n<\/span><\/span>\r\n\r\n\r\n<\/pre>\n<p>You can drop an existing column as follows.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People <b>DROP COLUMN<\/b> DateOfBirth;\r\n<\/span><\/span><\/pre>\n<p>You can rename column name as follows using alter command.<\/p>\n<pre><span class=\"fontstyle2\">\u00a0<\/span><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">rename column <\/span><span class=\"fontstyle3\">employee_id <\/span><span class=\"fontstyle3\">to <\/span><span class=\"fontstyle3\">emp_id<\/span><span class=\"fontstyle3\">;\r\n<\/span><\/pre>\n<p> <\/p>\n<p>You can convert table into read-only and read write mode as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">read only;\r\n<\/span>\r\n\r\nSQL> alter table msdeveci.mytest read only;\r\n\r\nTable altered.\r\n\r\nSQL> alter table msdeveci.mytest read write;\r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>You can rename an existing table as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">rename to <\/span><span class=\"fontstyle3\">myemployee<\/span><span class=\"fontstyle3\">;<\/span><\/pre>\n<p> <\/p>\n<p>You can add new partition to existing table as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">add partition <\/span><span class=\"fontstyle3\">part <\/span><span class=\"fontstyle3\">values (<\/span><span class=\"fontstyle3\">\u2018G3_201407_07<\/span><span class=\"fontstyle3\">');<\/span><\/pre>\n<p> <\/p>\n<p><span class=\"fontstyle3\">You can add primary key or constraint as follows.<br \/>\n<\/span><\/p>\n<pre><span class=\"fontstyle3\">ALTER TABLE <\/span><span class=\"fontstyle3\">HR<\/span><span class=\"fontstyle3\">.<\/span><span class=\"fontstyle3\">EMPLOYEES <\/span><span class=\"fontstyle3\">ADD (CONSTRAINT <\/span><span class=\"fontstyle3\">EMP_EMP_ID_PK <\/span><span class=\"fontstyle3\">PRIMARY KEY (<\/span><span class=\"fontstyle3\">EMP_ID<\/span><span class=\"fontstyle3\">));<\/span><\/pre>\n<p> <\/p>\n<p>You can disable and enable existing contraint as follows.<\/p>\n<pre> <span class=\"fontstyle0\">ALTER TABLE <\/span><span class=\"fontstyle0\">HR<\/span><span class=\"fontstyle0\">.<\/span><span class=\"fontstyle0\">DEPARTMENTS <\/span><span class=\"fontstyle0\">DISABLE CONSTRAINT <\/span><span class=\"fontstyle0\">DEPT_LOC_FK<\/span><span class=\"fontstyle0\">;<\/span>\r\n\r\n<span class=\"fontstyle0\">\r\nALTER TABLE <\/span><span class=\"fontstyle0\">HR<\/span><span class=\"fontstyle0\">.<\/span><span class=\"fontstyle0\">DEPARTMENTS <\/span><span class=\"fontstyle0\">ENABLE CONSTRAINT <\/span><span class=\"fontstyle0\">DEPT_LOC_FK;<\/span><\/pre>\n<p> <\/p>\n<p>You can rename an existing table as follows.<\/p>\n<pre>SQL> alter table msdeveci.test_table rename to mytest; \r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>You can add new column, drop existing column and modify column as follows.<\/p>\n<pre>SQL> alter table msdeveci.mytest add city varchar2(24);\r\n\r\nTable altered.\r\n\r\nSQL> alter table msdeveci.mytest modify city varchar2(36);\r\n\r\nTable altered.\r\n\r\n\r\n\r\nSQL> alter table msdeveci.mytest drop column city;\r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<h4><span style=\"color: #ff0000;\">Dou want to learn Oracle SQL Tutorial for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"RYWhnNSlGj\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/\">Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course<\/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 SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/embed\/#?secret=InW3RB7kI1#?secret=RYWhnNSlGj\" data-secret=\"RYWhnNSlGj\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I will explain Alter Table and Alter Table Add or Drop Column 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":[12137,12135,12150,12140,12143,12146,12134,20457,12149,12151,12136,12139,12141,12138,12145,12133,12152,12148,12144,12147,9037,11351,11304,3001,11302,2673,11301,3715,12142],"class_list":["post-16899","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-alter-column-datatype-in-sql","tag-alter-column-sql","tag-alter-table-add-column","tag-alter-table-add-column-oracle","tag-alter-table-add-column-oracle-default-value","tag-alter-table-add-constraint-oracle","tag-alter-table-add-multiple-columns","tag-alter-table-and-alter-table-add-or-drop-column-in-oracle-sql","tag-alter-table-drop-column","tag-alter-table-drop-column-oracle","tag-alter-table-modify-column-oracle","tag-alter-table-oracle","tag-alter-table-oracle-add-column","tag-alter-table-rename-column","tag-alter-table-rename-column-oracle","tag-alter-table-sql","tag-oracle-alter-table-add-column","tag-oracle-alter-table-add-column-after","tag-oracle-alter-table-drop-column","tag-oracle-alter-table-modify-column-nullable","tag-oracle-dba-tutorial","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-update-table-oracle"],"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\/16899","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=16899"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16899\/revisions"}],"predecessor-version":[{"id":35364,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16899\/revisions\/35364"}],"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=16899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27<\/a><\/p><\/blockquote>\n<\/iframe><\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n\n<p> <\/p>\n<h3><span style=\"color: #ff0000;\">Alter Table<\/span><\/h3>\n<p>You can perform the following tasks using the Alter command.<\/p>\n<ul>\n<li>Rename Table<\/li>\n<li>Add Column<\/li>\n<li>Drop Column<\/li>\n<li>Rename Column<\/li>\n<li>Disable Constraint<\/li>\n<li>Enable Constraint<\/li>\n<li>Add Partition<\/li>\n<li>Drop Partition<\/li>\n<li>Read Only<\/li>\n<li>Read Write<\/li>\n<\/ul>\n<p> <\/p>\n<p>You can add new column as follows.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People<b> ADD<\/b> DateOfBirth date;\r\n<\/span><\/span>\r\n\r\n\r\n<\/pre>\n<p>You can drop an existing column as follows.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People <b>DROP COLUMN<\/b> DateOfBirth;\r\n<\/span><\/span><\/pre>\n<p>You can rename column name as follows using alter command.<\/p>\n<pre><span class=\"fontstyle2\">\u00a0<\/span><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">rename column <\/span><span class=\"fontstyle3\">employee_id <\/span><span class=\"fontstyle3\">to <\/span><span class=\"fontstyle3\">emp_id<\/span><span class=\"fontstyle3\">;\r\n<\/span><\/pre>\n<p> <\/p>\n<p>You can convert table into read-only and read write mode as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">read only;\r\n<\/span>\r\n\r\nSQL> alter table msdeveci.mytest read only;\r\n\r\nTable altered.\r\n\r\nSQL> alter table msdeveci.mytest read write;\r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>You can rename an existing table as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">rename to <\/span><span class=\"fontstyle3\">myemployee<\/span><span class=\"fontstyle3\">;<\/span><\/pre>\n<p> <\/p>\n<p>You can add new partition to existing table as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">add partition <\/span><span class=\"fontstyle3\">part <\/span><span class=\"fontstyle3\">values (<\/span><span class=\"fontstyle3\">\u2018G3_201407_07<\/span><span class=\"fontstyle3\">');<\/span><\/pre>\n<p> <\/p>\n<p><span class=\"fontstyle3\">You can add primary key or constraint as follows.<br \/>\n<\/span><\/p>\n<pre><span class=\"fontstyle3\">ALTER TABLE <\/span><span class=\"fontstyle3\">HR<\/span><span class=\"fontstyle3\">.<\/span><span class=\"fontstyle3\">EMPLOYEES <\/span><span class=\"fontstyle3\">ADD (CONSTRAINT <\/span><span class=\"fontstyle3\">EMP_EMP_ID_PK <\/span><span class=\"fontstyle3\">PRIMARY KEY (<\/span><span class=\"fontstyle3\">EMP_ID<\/span><span class=\"fontstyle3\">));<\/span><\/pre>\n<p> <\/p>\n<p>You can disable and enable existing contraint as follows.<\/p>\n<pre> <span class=\"fontstyle0\">ALTER TABLE <\/span><span class=\"fontstyle0\">HR<\/span><span class=\"fontstyle0\">.<\/span><span class=\"fontstyle0\">DEPARTMENTS <\/span><span class=\"fontstyle0\">DISABLE CONSTRAINT <\/span><span class=\"fontstyle0\">DEPT_LOC_FK<\/span><span class=\"fontstyle0\">;<\/span>\r\n\r\n<span class=\"fontstyle0\">\r\nALTER TABLE <\/span><span class=\"fontstyle0\">HR<\/span><span class=\"fontstyle0\">.<\/span><span class=\"fontstyle0\">DEPARTMENTS <\/span><span class=\"fontstyle0\">ENABLE CONSTRAINT <\/span><span class=\"fontstyle0\">DEPT_LOC_FK;<\/span><\/pre>\n<p> <\/p>\n<p>You can rename an existing table as follows.<\/p>\n<pre>SQL> alter table msdeveci.test_table rename to mytest; \r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>You can add new column, drop existing column and modify column as follows.<\/p>\n<pre>SQL> alter table msdeveci.mytest add city varchar2(24);\r\n\r\nTable altered.\r\n\r\nSQL> alter table msdeveci.mytest modify city varchar2(36);\r\n\r\nTable altered.\r\n\r\n\r\n\r\nSQL> alter table msdeveci.mytest drop column city;\r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<h4><span style=\"color: #ff0000;\">Dou want to learn Oracle SQL Tutorial for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"RYWhnNSlGj\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/\">Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course<\/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 SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/embed\/#?secret=InW3RB7kI1#?secret=RYWhnNSlGj\" data-secret=\"RYWhnNSlGj\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I will explain Alter Table and Alter Table Add or Drop Column 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":[12137,12135,12150,12140,12143,12146,12134,20457,12149,12151,12136,12139,12141,12138,12145,12133,12152,12148,12144,12147,9037,11351,11304,3001,11302,2673,11301,3715,12142],"class_list":["post-16899","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-alter-column-datatype-in-sql","tag-alter-column-sql","tag-alter-table-add-column","tag-alter-table-add-column-oracle","tag-alter-table-add-column-oracle-default-value","tag-alter-table-add-constraint-oracle","tag-alter-table-add-multiple-columns","tag-alter-table-and-alter-table-add-or-drop-column-in-oracle-sql","tag-alter-table-drop-column","tag-alter-table-drop-column-oracle","tag-alter-table-modify-column-oracle","tag-alter-table-oracle","tag-alter-table-oracle-add-column","tag-alter-table-rename-column","tag-alter-table-rename-column-oracle","tag-alter-table-sql","tag-oracle-alter-table-add-column","tag-oracle-alter-table-add-column-after","tag-oracle-alter-table-drop-column","tag-oracle-alter-table-modify-column-nullable","tag-oracle-dba-tutorial","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-update-table-oracle"],"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\/16899","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=16899"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16899\/revisions"}],"predecessor-version":[{"id":35364,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16899\/revisions\/35364"}],"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=16899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/iframe><\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n\n<p> <\/p>\n<h3><span style=\"color: #ff0000;\">Alter Table<\/span><\/h3>\n<p>You can perform the following tasks using the Alter command.<\/p>\n<ul>\n<li>Rename Table<\/li>\n<li>Add Column<\/li>\n<li>Drop Column<\/li>\n<li>Rename Column<\/li>\n<li>Disable Constraint<\/li>\n<li>Enable Constraint<\/li>\n<li>Add Partition<\/li>\n<li>Drop Partition<\/li>\n<li>Read Only<\/li>\n<li>Read Write<\/li>\n<\/ul>\n<p> <\/p>\n<p>You can add new column as follows.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People<b> ADD<\/b> DateOfBirth date;\r\n<\/span><\/span>\r\n\r\n\r\n<\/pre>\n<p>You can drop an existing column as follows.<\/p>\n<pre><span class=\"codeBlock\"><span class=\"code sql\"><b><span class=\"tooltip\">ALTER TABLE<\/span><\/b> People <b>DROP COLUMN<\/b> DateOfBirth;\r\n<\/span><\/span><\/pre>\n<p>You can rename column name as follows using alter command.<\/p>\n<pre><span class=\"fontstyle2\">\u00a0<\/span><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">rename column <\/span><span class=\"fontstyle3\">employee_id <\/span><span class=\"fontstyle3\">to <\/span><span class=\"fontstyle3\">emp_id<\/span><span class=\"fontstyle3\">;\r\n<\/span><\/pre>\n<p> <\/p>\n<p>You can convert table into read-only and read write mode as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">read only;\r\n<\/span>\r\n\r\nSQL> alter table msdeveci.mytest read only;\r\n\r\nTable altered.\r\n\r\nSQL> alter table msdeveci.mytest read write;\r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>You can rename an existing table as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">rename to <\/span><span class=\"fontstyle3\">myemployee<\/span><span class=\"fontstyle3\">;<\/span><\/pre>\n<p> <\/p>\n<p>You can add new partition to existing table as follows.<\/p>\n<pre><span class=\"fontstyle3\">alter table <\/span><span class=\"fontstyle3\">hr.employees <\/span><span class=\"fontstyle3\">add partition <\/span><span class=\"fontstyle3\">part <\/span><span class=\"fontstyle3\">values (<\/span><span class=\"fontstyle3\">\u2018G3_201407_07<\/span><span class=\"fontstyle3\">');<\/span><\/pre>\n<p> <\/p>\n<p><span class=\"fontstyle3\">You can add primary key or constraint as follows.<br \/>\n<\/span><\/p>\n<pre><span class=\"fontstyle3\">ALTER TABLE <\/span><span class=\"fontstyle3\">HR<\/span><span class=\"fontstyle3\">.<\/span><span class=\"fontstyle3\">EMPLOYEES <\/span><span class=\"fontstyle3\">ADD (CONSTRAINT <\/span><span class=\"fontstyle3\">EMP_EMP_ID_PK <\/span><span class=\"fontstyle3\">PRIMARY KEY (<\/span><span class=\"fontstyle3\">EMP_ID<\/span><span class=\"fontstyle3\">));<\/span><\/pre>\n<p> <\/p>\n<p>You can disable and enable existing contraint as follows.<\/p>\n<pre> <span class=\"fontstyle0\">ALTER TABLE <\/span><span class=\"fontstyle0\">HR<\/span><span class=\"fontstyle0\">.<\/span><span class=\"fontstyle0\">DEPARTMENTS <\/span><span class=\"fontstyle0\">DISABLE CONSTRAINT <\/span><span class=\"fontstyle0\">DEPT_LOC_FK<\/span><span class=\"fontstyle0\">;<\/span>\r\n\r\n<span class=\"fontstyle0\">\r\nALTER TABLE <\/span><span class=\"fontstyle0\">HR<\/span><span class=\"fontstyle0\">.<\/span><span class=\"fontstyle0\">DEPARTMENTS <\/span><span class=\"fontstyle0\">ENABLE CONSTRAINT <\/span><span class=\"fontstyle0\">DEPT_LOC_FK;<\/span><\/pre>\n<p> <\/p>\n<p>You can rename an existing table as follows.<\/p>\n<pre>SQL> alter table msdeveci.test_table rename to mytest; \r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p>You can add new column, drop existing column and modify column as follows.<\/p>\n<pre>SQL> alter table msdeveci.mytest add city varchar2(24);\r\n\r\nTable altered.\r\n\r\nSQL> alter table msdeveci.mytest modify city varchar2(36);\r\n\r\nTable altered.\r\n\r\n\r\n\r\nSQL> alter table msdeveci.mytest drop column city;\r\n\r\nTable altered.\r\n\r\nSQL><\/pre>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<p> <\/p>\n<h4><span style=\"color: #ff0000;\">Dou want to learn Oracle SQL Tutorial for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"RYWhnNSlGj\"><p><a href=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/\">Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course<\/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 SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course” — IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-sql-tutorials-for-beginners-learn-sql-tutorials-sql-course\/embed\/#?secret=InW3RB7kI1#?secret=RYWhnNSlGj\" data-secret=\"RYWhnNSlGj\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I will explain Alter Table and Alter Table Add or Drop Column 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":[12137,12135,12150,12140,12143,12146,12134,20457,12149,12151,12136,12139,12141,12138,12145,12133,12152,12148,12144,12147,9037,11351,11304,3001,11302,2673,11301,3715,12142],"class_list":["post-16899","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle-sql","tag-alter-column-datatype-in-sql","tag-alter-column-sql","tag-alter-table-add-column","tag-alter-table-add-column-oracle","tag-alter-table-add-column-oracle-default-value","tag-alter-table-add-constraint-oracle","tag-alter-table-add-multiple-columns","tag-alter-table-and-alter-table-add-or-drop-column-in-oracle-sql","tag-alter-table-drop-column","tag-alter-table-drop-column-oracle","tag-alter-table-modify-column-oracle","tag-alter-table-oracle","tag-alter-table-oracle-add-column","tag-alter-table-rename-column","tag-alter-table-rename-column-oracle","tag-alter-table-sql","tag-oracle-alter-table-add-column","tag-oracle-alter-table-add-column-after","tag-oracle-alter-table-drop-column","tag-oracle-alter-table-modify-column-nullable","tag-oracle-dba-tutorial","tag-oracle-live-sql","tag-oracle-sql-developer-tutorial","tag-oracle-sql-tutorial","tag-oracle-sql-tutorial-pdf","tag-oracle-tutorial","tag-oracle-tutorial-pdf","tag-pl-sql-tutorial","tag-update-table-oracle"],"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\/16899","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=16899"}],"version-history":[{"count":5,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16899\/revisions"}],"predecessor-version":[{"id":35364,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/16899\/revisions\/35364"}],"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=16899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=16899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=16899"}],"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