Oracle教程 2023-04-01

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

Oracle 内置视图 ALL_SQL_TRANSLATION_PROFILES 用于获取当前数据库实例所有 SQL 语句转换配置，并将此配置显示到表中。界面字段信息如下：

OWNER：该语句转换配置的所有者。

PROFILE_NAME：该语句转换配置的名称。

PROFILES：该语句转换配置的具体内容。

使用方法：

1）通过ALL_SQL_TRANSLATION_PROFILES查询当前用户名下拥有的SQL转换配置，以确认是否拥有某一SQL转换配置：

SQL> SELECT * FROM ALL_SQL_TRANSLATION_PROFILES WHERE OWNER=’CURRENT_USER’ ORDER BY PROFILE_NAME;

2）为某一会话级别添加一个SQL转换配置：

SQL> ALTER SESSION SET SQL_TRANSLATION_PROFILE=’APP_PROFILE_TONGLI’;

ALL_SQL_TRANSLATION_PROFILES describes all SQL translation profiles accessible to the user.

Related Views

DBA_SQL_TRANSLATION_PROFILES describes all SQL translation profiles in the database.
USER_SQL_TRANSLATION_PROFILES describes all SQL translation profiles owned by the user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the SQL translation profile
`PROFILE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the SQL translation profile
`TRANSLATOR`	`VARCHAR2(261)`		The translator package
`FOREIGN_SQL_SYNTAX`	`VARCHAR2(5)`		Indicates whether the SQL syntax is foreign. Possible values: `TRUE` `FALSE`
`TRANSLATE_NEW_SQL`	`VARCHAR2(5)`		Indicates whether to translate new SQL statements and errors using the translator. Possible values: `TRUE` `FALSE`
`RAISE_TRANSLATION_ERROR`	`VARCHAR2(5)`		Indicates whether to raise translation error. Possible values: `TRUE` `FALSE`
`LOG_TRANSLATION_ERROR`	`VARCHAR2(5)`		Indicates whether to log translation error. Possible values: `TRUE` `FALSE`
`TRACE_TRANSLATION`	`VARCHAR2(5)`		Indicates whether to trace translation. Possible values: `TRUE` `FALSE`
`LOG_ERRORS`	`VARCHAR2(5)`		Indicates whether there are log errors (`TRUE`) or not (`FALSE`)