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

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...