oracle 常用语句

1.查找表对应的所有字段

?

SELECT * FROM all_tab_cols WHERE owner = UPPER('username') AND table_name = UPPER('tablename')ORDER BY COLUMN_ID;