DBMS/oracle

[oracle] - 컬럼생성 스크립트

짱가쟁이 2011. 6. 24. 10:38

ALTER TABLE  TABLE_NAME ADD ( LOC_X VARCHAR2(32), LOC_Y VARCHAR2(32) );

COMMENT ON COLUMN TABLE_NAME.LOC_X IS '경도';
COMMENT ON COLUMN TABLE_NAME.LOC_Y IS '위도';