select * from all_tables where table_name = '大写表名';
SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME='STUDENT' 可以列出所有student表中的字段
错了 是 select * from all_tab_columns where table_name = '大写表名';
SELECT COLUMN_NAME, DATA_TYPE, DATA_TYPE_MOD, DATA_TYPE_OWNER, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE FROM USER_TAB_COLUMNS WHERE TABLE_NAME=已知表 AND COLUMN_NAME NOT IN (已知字段名);
可以列出所有student表中的字段
select * from all_tab_columns where table_name = '大写表名';
FROM USER_TAB_COLUMNS WHERE TABLE_NAME=已知表 AND COLUMN_NAME NOT IN (已知字段名);