오라클 컬럼 추가 삭제 변경

컬럼 추가 :

 ALTER TABLE [table name]
       ADD ( [column name] [datatype], ... );

For 예시:

 ALTER TABLE employee
       ADD (id int)

컬럼명(rename) 변경:

 ALTER TABLE [table name]
       RENAME COLUMN [column name] TO [new column name] );

예시:

 ALTER TABLE employee
       RENAME COLUMN col_01 TO col_02;

컬럼 속성(modify) 변경:

 ALTER TABLE [table name]
       MODIFY ( [column name] [new datatype] );

예시:

 ALTER TABLE employee
       MODIFY( sickHours float );

컬럼 삭제 :

 ALTER TABLE [table name]
       DROP COLUMN [column name];

예시:

 ALTER TABLE employee
       DROP COLUMN vacationPay;