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 '위도';
COMMENT ON COLUMN TABLE_NAME.LOC_X IS '경도';
COMMENT ON COLUMN TABLE_NAME.LOC_Y IS '위도';