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

VIEW: SYS.CDB_SQL_TRANSLATIONS

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

Describes all SQL translations in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the SQL translation profile
PROFILE_NAME VARCHAR2 (30) 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_SQL_TRANSLATIONS;

Dependencies

[top of page]

SYS.CDB_SQL_TRANSLATIONS does not reference any database object

SYS.CDB_SQL_TRANSLATIONS is referenced by following:

SchemaPUBLIC
SynonymCDB_SQL_TRANSLATIONS