ORACEL Using scripts to modify table structure

  • 2021-11-02 03:26:07
  • OfStack

ORACLE can modify the table structure with the following script.
 
ALTER TABLE TABLE_NAME 
ADD COL_NAME VARCHAR2(2000) ;  

 
ALTER TABLE TABKE_NAME 
DROP COLUMN COL_NAME; 

Related articles: