Oracle 12c中的ALL_TAB_COLUMNS和ALL_TAB_COLS系统表有什么区别？在我的数据库中,ALL_TAB_COLUMNS的行数比ALL_TAB_COLS略少.
解决方法
From the Oracle manual for ALL_TAB_COLS
This view differs from “ALL_TAB_COLUMNS” in that system-generated hidden columns and invisible columns,which are user-generated hidden columns,are not filtered out.
From the Oracle manual for ALL_TAB_COLUMNS
This view filters out system-generated hidden columns and invisible columns,which are user-generated hidden columns. The ALL_TAB_COLS view does not filter out hidden columns and invisible columns
