Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_SQL_TRANSLATIONS

ALL_SQL_TRANSLATIONS describes all SQL translations accessible to the user.

Related Views

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