查询表的列名,字符类型 SELECT table_name, column_name, data_type FROM all_tab_cols WHERE table_name = '表名(必须大写)';