ORACLE备忘录

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 = '表名';