Oracle教程 2023-02-24

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

Oracle视图V$TIMEZONE_FILE是一种虚拟视图，它用来列出当前安装在数据库中的全部时区文件，我们可以通过该视图访问数据库中所有时区文件的信息。

该视图定义了几个列，比如：

ID：定义了服务器上的时区文件ID。

FILENAME：定义了数据库服务器上时区文件的文件名称。

TIMESTAMP：定义了该时区文件的时间戳。

DESCRIPTION：定义了该时区文件的描述信息。

使用V$TIMEZONE_FILE视图访问数据库中的时区文件信息，只需要在SQL查询命令行中编写下面的语句：

SELECT * FROM V$TIMEZONE_FILE;

该语句将会返回当前安装在数据库服务器中的时区文件的ID、名称、时间戳以及描述信息的所有信息。

V$TIMEZONE_FILE describes the time zone file that is currently in use by the database.

Column Datatype Description

Column	Datatype	Description
`FILENAME`	`VARCHAR2(20)`	Time zone file name
`VERSION`	`NUMBER`	Time zone file version
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

FILENAME

VARCHAR2(20)

Time zone file name

VERSION

NUMBER

Time zone file version

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data

分享到：