查询Oracle表列中长度、类型:
SELECT table_name,column_name,data_type,DATA_LENGTH FROM all_tab_cols WHERE table_name = '表名' and column_name = '列名';
提示:Oracle表名、列名都是大写