DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_SQL_TRANSLATIONS

Object Details
Object Name: ALL_SQL_TRANSLATIONS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Describes all SQL translations accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the SQL translation profile
PROFILE_NAME VARCHAR2 (128) Yes Name of the SQL translation profile
SQL_TEXT CLOB (4000) Yes The SQL text
TRANSLATED_TEXT CLOB (4000)
The translated SQL text
SQL_ID VARCHAR2 (13) Yes SQL identifier of the SQL text
HASH_VALUE NUMBER
Yes Hash value of the SQL text
ENABLED VARCHAR2 (5)
Is the translation enabled?
REGISTRATION_TIME TIMESTAMP(6) (11)
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      PROFILE_NAME
,      SQL_TEXT
,      TRANSLATED_TEXT
,      SQL_ID
,      HASH_VALUE
,      ENABLED
,      REGISTRATION_TIME
,      CLIENT_INFO
,      MODULE
,      ACTION
,      PARSING_USER_ID
,      PARSING_SCHEMA_ID
,      COMMENTS
FROM SYS.ALL_SQL_TRANSLATIONS;

Dependencies

[top of page]

SYS.ALL_SQL_TRANSLATIONS references the following:

SchemaSYS
TableOBJAUTH$
TableSQLTXL_SQL$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.ALL_SQL_TRANSLATIONS is referenced by following:

SchemaPUBLIC
SynonymALL_SQL_TRANSLATIONS
SchemaSYS
Package BodyDBMS_SQL_TRANSLATOR - show dependent code