1、查看包体内容:
SELECT TEXT FROM USER_SOURCE WHERE NAME = '包体名';
2、查看注解:
SELECT USER_TAB_COLS.COLUMN_ID, USER_TAB_COLS.COLUMN_NAME,
USER_TAB_COLS.DATA_TYPE, USER_TAB_COLS.DATA_LENGTH,
USER_TAB_COLS.NULLABLE, USER_COL_COMMENTS.COMMENTS
FROM USER_TAB_COLS INNER JOIN USER_COL_COMMENTS ON
USER_COL_COMMENTS.TABLE_NAME = USER_TAB_COLS.TABLE_NAME
AND USER_COL_COMMENTS.COLUMN_NAME = USER_TAB_COLS.COLUMN_NAME
WHERE USER_TAB_COLS.TABLE_NAME = '表名';