Clever Geek Handbook

Difference between SYS.ALL_TAB_COLUMNS and SYS.ALL_TAB_COLS in Oracle 12c

What is the difference between system tables ALL_TAB_COLUMNS

and ALL_TAB_COLS

in Oracle 12c? In my DB, ALL_TAB_COLUMNS has slightly fewer rows than ALL_TAB_COLS.

+3


source to share


2 answers


From 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-created hidden columns, are not filtered out.



From Oracle manual for ALL_TAB_COLUMNS

This view filters out system-generated hidden columns and invisible columns, which are user-generated hidden columns. ALL_TAB_COLS view does not filter out hidden columns and invisible columns

+7


source


ALL_TAB_COLUMNS contains only user-defined columns, while ALL_TAB_COLS also contains some system columns in each user-defined table that are not normally visible.



0


source






More articles:


All Articles