VIEW: SYS.DBA_SQL_TRANSLATIONS

Source

View Text - Preformatted

select u.name, o.name, s.sqltext, s.txltext, s.sqlid, s.sqlhash,
       decode(bitand(s.flags, 1), 1, 'TRUE', 0, 'FALSE'),
       s.rtime, s.cinfo, s.module, s.action, s.puser#, s.pschema#, s.comment$
  from sys.sqltxl_sql$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u
 where s.obj# = o.obj# and
       o.owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, S.SQLTEXT
, S.TXLTEXT
, S.SQLID
, S.SQLHASH
, DECODE(BITAND(S.FLAGS
, 1)
, 1
, 'TRUE'
, 0
, 'FALSE')
, S.RTIME
, S.CINFO
, S.MODULE
, S.ACTION
, S.PUSER#
, S.PSCHEMA#
, S.COMMENT$
FROM SYS.SQLTXL_SQL$ S
, SYS."_CURRENT_EDITION_OBJ" O
, SYS.USER$ U
WHERE S.OBJ# = O.OBJ# AND O.OWNER# = U.USER#