执行这个sql语句,把查询结果导出、打印就可以了 select TABLE_NAME,COLUMN_NAME ,DATA_TYPE||decode(DATA_TYPE,'VARCHAR2','('||DATA_LENGTH||')','NUMBER','('||DATA_LENGTH||decode(DATA_SCALE,0,'',null,'',','||DATA_SCALE)||')','') from dba_tab_columns where owner='你的数据库用户' ORDER BY TABLE_NAME,COLUMN_NAME;
dba用户才可以查询dba_tab_columns
select TABLE_NAME,COLUMN_NAME
,DATA_TYPE||decode(DATA_TYPE,'VARCHAR2','('||DATA_LENGTH||')','NUMBER','('||DATA_LENGTH||decode(DATA_SCALE,0,'',null,'',','||DATA_SCALE)||')','')
from dba_tab_columns where owner='你的数据库用户'
ORDER BY TABLE_NAME,COLUMN_NAME;