1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_SQL_TRANSLATIONS

3.76 ALL_SQL_TRANSLATIONS

ALL_SQL_TRANSLATIONS describes all SQL translations accessible to the user.

Related Views

  • DBA_SQL_TRANSLATIONS describes all SQL translations in the database.

  • USER_SQL_TRANSLATIONS describes all SQL translations 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

SQL_TEXT

CLOB

NOT NULL

The SQL statement

TRANSLATED_TEXT

CLOB

The translated SQL statement

SQL_ID

VARCHAR2(13)

NOT NULL

SQL identifier of the SQL statement

HASH_VALUE

NUMBER

NOT NULL

Hash value of the SQL statement

ENABLED

VARCHAR2(5)

Displays whether the translation is enabled. Possible values:

  • TRUE

  • FALSE

REGISTRATION_TIME

TIMESTAMP(6)

Time the translation was registered

CLIENT_INFO

VARCHAR2(64)

Client information when the SQL was parsed and the translation was registered

MODULE

VARCHAR2(64)

Module when the SQL was parsed and the translation was registered

ACTION

VARCHAR2(64)

Action when the SQL was parsed and the translation was registered

PARSING_USER_ID

NUMBER

Current user ID when the SQL was parsed and the translation was registered

PARSING_SCHEMA_ID

NUMBER

Current schema ID when the SQL was parsed and the translation was registered

COMMENTS

VARCHAR2(4000)

Comment on the translation

ERROR_CODE

NUMBER

Last error code when the SQL was run

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

ERROR_SOURCE

VARCHAR2(9)

Source of the last error

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

TRANSLATION_METHOD

VARCHAR2(10)

Method used to translate the SQL during the last error

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

DICTIONARY_SQL_ID

VARCHAR2(13)

SQL identifier of the SQL text in the translation dictionary used to translate the SQL during the last error

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

See Also: