Thursday, July 18, 2013

DBA_TAB_COLS and friends

Table                Scope                Types     Hidden_Cols_Filtered
DBA_TAB_COLS        in the database      T,W,C      No
DBA_TAB_COLUMNS     in the database      T,W,C      Yes

ALL_TAB_COLS        accessible to user   T,W,C      No
ALL_TAB_COLUMNS     accessible to user   T,W,C      Yes

USER_TAB_COLS       owned by user        T,W,C      No
USER_TAB_COLUMNS    owned by user        T,W,C      Yes

all_table_cols  mistype of ALL_TAB_COLS
user_table_cols mistype of USER_TAB_COLS

No comments:

Post a Comment