从oracle导表结构及字段含义到excel的SQL

select t.table_name,t.column_name,t.data_type|| '(' || t.data_length || ')',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;