Oracle 视图 USER_TAB_COLS 官方解释，作用，如何使用详细说明
本站中文解释
视图用于查询某个用户下所有表的字段信息，可以使用指定的用户名在VIEW_NAME中指定表查询，以便查看其中的字段名称、类型、长度等具体信息。例如：
SELECT *
FROM USER_TAB_COLS
WHERE OWNER =’用户名’
AND TABLE_NAME = ‘表名’;
官方英文解释
USER_TAB_COLS describes the columns of the tables, views, and clusters owned by the current user.
Its columns (except for OWNER) are the same as those in ALL_TAB_COLS.
To gather statistics for this view, use the DBMS_STATS package.
This view differs from USER_TAB_COLUMNS in that system-generated hidden columns are not filtered out.
See Also:
-
“ALL_TAB_COLS”
-
“USER_TAB_COLUMNS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_STATSpackage
