https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2094.htm
3.105 ALL_TAB_COLUMNS
ALL_TAB_COLUMNS
describes the columns of the tables, views, and clusters accessible to the current user. To gather statistics for this view, use the ANALYZE
SQL statement or the DBMS_STATS
package.
SELECT * FROM ALL_TAB_COLUMNS a WHERE a.OWNER IN('FUD') AND a.TABLE_NAME IN ('SION')
Related Views
-
DBA_TAB_COLUMNS
describes the columns of all tables, views, and clusters in the database. -
USER_TAB_COLUMNS
describes the columns of the tables, views, and clusters owned by the current user. This view does not display theOWNER
column.
6.31 DBA_TAB_COLS
DBA_TAB_COLS
describes the columns of all tables, views, and clusters in the database.
Its columns (except for SENSITIVE_COLUMN
) are the same as those in ALL_TAB_COLS
.
To gather statistics for this view, use the DBMS_STATS
package.
This view differs from DBA_TAB_COLUMNS
in that system-generated hidden columns are not filtered out.
2.80 ALL_COL_COMMENTS ALL_COL_COMMENTS
ALL_COL_COMMENTS
displays comments on the columns of the tables and views accessible to the current user.
Related Views
-
DBA_COL_COMMENTS
displays comments on the columns of all tables and views in the database. -
USER_COL_COMMENTS
displays comments on the columns of the tables and views owned by the current user. This view does not display theOWNER
column.
SELECT * FROM ALL_COL_COMMENTS a where a.OWNER in ('FUD') and a.TABLE_NAME in ('test_SION')
2.86 ALL_CONS_COLUMNS
ALL_CONS_COLUMNS
describes columns that are accessible to the current user and that are specified in constraints.
SELECT * FROM ALL_CONS_COLUMNS a where a.OWNER in ('FUD') and a.TABLE_NAME in ('SION')
Related Views
-
DBA_CONS_COLUMNS
describes all columns in the database that are specified in constraints. -
USER_CONS_COLUMNS
describes columns that are owned by the current user and that are specified in constraints.