数据字典.sql
SELECT T.TABLE_NAME,
T.COLUMN_NAME,
T.DATA_TYPE || '(' || T.DATA_LENGTH || ')' DATA_TYPE,
T1.COMMENTS
FROM USER_TAB_COLS T, USER_COL_COMMENTS T1
WHERE T.TABLE_NAME = T1.TABLE_NAME
AND T.COLUMN_NAME = T1.COLUMN_NAME
查看安装数据的版本信息
SELECT * FROM V$VERSION