Oracle教程 2023-04-05

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

Oracle视图ALL_CERTIFICATES是一个数据字典视图，它提供了当前用户所拥有的X.509 证书的信息，包括证书类型、Issuer、Subject Name、 Serial Number 等信息。

要使用Oracle视图ALL_CERTIFICATES，首先需要配置相应的X.509 证书。如果你的当前用户有X.509 证书，那么查询ALL_CERTIFICATES视图就可以获取X.509 证书的相关信息。

查询示例：
SELECT * FROM ALL_CERTIFICATES;

ALL_CERTIFICATES displays the certificates accessible to the current user which are used for signature verification for blockchain tables.

Related Views

DBA_CERTIFICATES displays all certificates in the database which are used for signature verification for blockchain tables.
USER_CERTIFICATES displays the certificates added by the current user which are used for signature verification for blockchain tables. This view does not display the USER_NAME column.

Column	Datatype	NULL	Description
`CERTIFICATE_ID`	`RAW(16)`	`NOT NULL`	ID for the certificate
`USER_NAME`	`VARCHAR2(128)`	`NOT NULL`	User who added the certificate
`DISTINGUISHED_NAME`	`VARCHAR2(2000)`		Uniquely identifies the entity that owns the certificate
`CERTIFICATE`	`BLOB`		Contents of the certificate

Note:

This view is available starting with Oracle Database 21c.