Tuesday, November 25, 2008

Oracle - Data Dictionary views Part - 2

USER_CONS_COLUMNS, ALL_CONS_ COLUMNS, DBA_ CONS_ COLUMNS:
Displays information about table columns that have constraints owned by or available to the current user, respectively, or all table columns in Oracle that have constraints on them.

USER_IND_COLUMNS, ALL_IND_ COLUMNS, DBA_ IND_ COLUMNS:
Displays information about table columns that have indexes owned by or available to the current user, respectively, or all table columns in Oracle that have indexes on them.

USER_TAB_COLUMNS, ALL_TAB_ COLUMNS, DBA_ TAB_ COLUMNS:
Displays information about columns in table owned by or available to the current user, respectively, or all columns in all tables in Oracle.


USER_ROLES, ALL_ ROLES, DBA_ ROLES:
Displays information about rows owned by or available to the current user, respectively, or all roles in Oracle database.

USER_TAB_PRIVS, ALL_TAB_PRIVS, DBA_ TAB_PRIVS:
Displays information about object privileges on objects owned by or available to the current user, respectively, or all object privileges available to all users in Oracle.

No comments: