读取指定表的所有列名:
SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = '表名' ORDER BY COLUMN_ID;
读取指定表某一列的所有数据:
SELECT columnName FROM tableName;
读取指定表的所有列名:
SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME = '表名' ORDER BY COLUMN_ID;
读取指定表某一列的所有数据:
SELECT columnName FROM tableName;