Mark 一下 原先有人贴过一个很长的SQL语句,可以查出来然后导出成Excel表就可以了 可惜收藏的不见了 现在自己也想用,晕
试试这个select substr(table_name,1,20) tabname, substr(column_name,1,20)column_name, rtrim(data_type)||'('||data_length||')' from system.dba_tab_columns where owner='username'
Select TNAME ,COLNO ,CNAME ,COLTYPE,WIDTH,SCALE,Precision From COL Order By TNAME,COLNO
select a.table_name,b.column_name from all_tables a,ALL_CONS_COLUMNS b where a.owner in ('SP') and a.owner = b.owner and a.table_name = b.table_name order by a.table_name;
select table_name,column_name,data_type,data_length from user_tab_columns 便是当前用户下所有的表名,列名,数据类型,和数据长度.
AT PL/SQL ON RESULT SELECT ALL CHICKE MOUSE RIHT KEY EXPROT TO HTML
原先有人贴过一个很长的SQL语句,可以查出来然后导出成Excel表就可以了
可惜收藏的不见了
现在自己也想用,晕
substr(column_name,1,20)column_name,
rtrim(data_type)||'('||data_length||')' from system.dba_tab_columns
where owner='username'
Order By TNAME,COLNO
and a.owner = b.owner and a.table_name = b.table_name
order by a.table_name;
便是当前用户下所有的表名,列名,数据类型,和数据长度.