3.76 ALL_SQL_TRANSLATIONS
ALL_SQL_TRANSLATIONS describes all SQL translations accessible to the user.
Related Views
-
DBA_SQL_TRANSLATIONSdescribes all SQL translations in the database. -
USER_SQL_TRANSLATIONSdescribes all SQL translations owned by the user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the SQL translation profile |
|
|
|
|
Name of the SQL translation profile |
|
|
|
|
The SQL statement |
|
|
|
|
The translated SQL statement |
|
|
|
|
SQL identifier of the SQL statement |
|
|
|
|
Hash value of the SQL statement |
|
|
|
|
Displays whether the translation is enabled. Possible values:
|
|
|
|
|
Time the translation was registered |
|
|
|
|
Client information when the SQL was parsed and the translation was registered |
|
|
|
|
Module when the SQL was parsed and the translation was registered |
|
|
|
|
Action when the SQL was parsed and the translation was registered |
|
|
|
|
Current user ID when the SQL was parsed and the translation was registered |
|
|
|
|
Current schema ID when the SQL was parsed and the translation was registered |
|
|
|
|
Comment on the translation |
|
|
|
|
Last error code when the SQL was run |
|
|
|
|
Source of the last error |
|
|
|
|
Method used to translate the SQL during the last error |
|
|
|
|
SQL identifier of the SQL text in the translation dictionary used to translate the SQL during the last error |
See Also: