自己找到了.
select column_name, nullable, data_type,data_length, data_precision from dba_tab_columns where owner='XXX' and table_name='XXXX';
select column_name, nullable, data_type,data_length, data_precision from dba_tab_columns where owner='XXX' and table_name='XXXX';
多浪费啊