Saturday, January 6, 2018

Drop Structure


Column Drop (be Carefull) 

alter table table_name drop column col_name1;  --one column table
/
alter table table_name drop(col_name1, col_name2)  --more columns in table 

--------------------

alter table APPLPATH12c drop column FOLDER;

/

alter table APPLPATH12c drop (IP3,IP2);  

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...