--VIEW OBJECT 註解
COMMENT ON TABLE ALL_RATE_D IS '財管匯率彙總檔';

--QUERY VIEW OBJECT 註解
SELECT * FROM USER_TAB_COMMENTS WHERE TABLE_NAME='ALL_RATE_D';

--QUERY VIEW COLUMN 註解
SELECT * FROM USER_COL_COMMENTS WHERE TABLE_NAME='ALL_RATE_D'

--COLUMN 短註解
COMMENT ON COLUMN ALL_RATE_D.SNAP_DATE IS '資料日期';
COMMENT ON COLUMN ALL_RATE_D.CUR IS '幣別';
COMMENT ON COLUMN ALL_RATE_D.B_RATE IS '買價匯率';
COMMENT ON COLUMN ALL_RATE_D.S_RATE IS '賣價匯率';
COMMENT ON COLUMN ALL_RATE_D.S_RATE IS '賣價匯率';

--COLUMN長註解
COMMENT ON COLUMN ALL_RATE_D.AVG_RATE
  IS
'中價匯率
(買價+賣價)/2  
';

COMMIT;