Oracle教程 2023-02-27

Oracle 视图 ALL_TSTZ_TAB_COLS 官方解释，作用，如何使用详细说明

本站中文解释

ALL_TSTZ_TAB_COLS是一种Oracle视图，用来获取与时区作为时间戳的表列的详细信息。通过它，用户可以得出该表格中每一列的类型、定义等信息。

使用ALL_TSTZ_TAB_COLS时，需要在SELECT语句中指定表格的名称，以此来确定你想要查询的具体表格。例如：SELECT * FROM ALL_TSTZ_TAB_COLS WHERE table_name=’your_table_name’ 将可以查询到你表格中所有的列名称、类型等信息。

通过使用ALL_TSTZ_TAB_COLS，可以快速获取表格列信息，从而能够更好地利用该表格进行分析。

官方英文解释

ALL_TSTZ_TAB_COLS displays information about the columns of the tables accessible to the current user, which have columns defined on TIMESTAMP WITH TIME ZONE data types or object types containing attributes of TIMESTAMP WITH TIME ZONE data types.

Related Views

DBA_TSTZ_TAB_COLS displays information about the columns of all tables in the database, which have columns defined on TIMESTAMP WITH TIME ZONE data types or object types containing attributes of TIMESTAMP WITH TIME ZONE data types. This view does not display the COLUMN_NAME, NESTED, and VIRTUAL_COLUMN columns.
USER_TSTZ_TAB_COLS displays information about the columns of the tables owned by the current user, which have columns defined on TIMESTAMP WITH TIME ZONE data types or object types containing attributes of TIMESTAMP WITH TIME ZONE data types. This view does not display the OWNER, COLUMN_NAME, NESTED, and VIRTUAL_COLUMN columns.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the table
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Column name
`QUALIFIED_COL_NAME`	`VARCHAR2(4000)`		Qualified column name
`NESTED`	`NUMBER`		Indicates whether the column is a nested table (`1`) or not (`0`)
`VIRTUAL_COLUMN`	`NUMBER`		Indicates whether the column is a virtual column (`1`) or not (`0`)
`SCALAR_COLUMN`	`NUMBER`		Indicates whether the column is a scalar column (`1`) or not (`0`)
`UNUSED_COLUMN`	`NUMBER`		Indicates whether the column is an unused column (`1`) or not (`0`)

本站中文解释

官方英文解释

相关推荐