1.查找表对应的所有字段
SELECT * FROM all_tab_cols WHERE owner = UPPER('username') AND table_name = UPPER('tablename')
ORDER BY COLUMN_ID;
1.查找表对应的所有字段
SELECT * FROM all_tab_cols WHERE owner = UPPER('username') AND table_name = UPPER('tablename')
ORDER BY COLUMN_ID;