日期:2014-05-16  浏览次数:20446 次

oracle 常用语句

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

?

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