日期:2014-05-16  浏览次数:20480 次

Oracle 注释
--给表加注释
COMMENT?ON?TABLE?TABLENAME?IS?'用户表'?;
--查看表的COMMENT
SELECT?*?FROM?USER_TAB_COMMENTS?WHERE?TABLE_NAME=?'TABLENAME';
--给字段加注释
COMMENT?ON?COLUMN?TABLENAME.COLNAME?IS?'OOXX'?;
--查看字段的COMMENT
SELECT?