SQL中查询整表的字段最大长度 ,Cursor

analyze table db_name.table_name compute statistics for columns;
select * from TAB_COL_STATS@system_dblink where db_name = 'db_name' and table_name = 'table_name';

例如：

analyze table ADS.USR_CRMFUTURES_DF compute statistics for columns;
select column_name,max_col_len from TAB_COL_STATS@system_dblink where db_name = 'ADS' and table_name = 'USR_CRMFUTURES_DF';

mermaid.live