查询表的列名,字符类型

SELECT table_name, column_name, data_type
FROM all_tab_cols
WHERE table_name = '表名(必须大写)';

原文地址:https://www.cnblogs.com/duyunchao-2261/p/6728252.html