查询表字段注释
SELECT TABLE_NAME,COLUMN_NAME,COMMENTS FROM USER_COL_COMMENTS WHERE TABLE_NAME = 'S_CODE_BASE';
查询序列
SELECT ' CREATE SEQUENCE '||SEQUENCE_NAME|| ' INCREMENT BY '||
INCREMENT_BY ||' START WITH '||LAST_NUMBER||' MAXVALUE '||
MAX_VALUE ||' CACHE '||CACHE_SIZE||' ORDER NOCYCLE ;'
FROM user_SEQUENCES;