DBA Data[Home] [Help]

VIEW: SYS.V_$MAPPED_SQL

Source

View Text - Preformatted

select "SQL_TEXT","SQL_FULLTEXT","SQL_ID","HASH_VALUE","MAPPED_SQL_TEXT","MAPPED_SQL_FULLTEXT","MAPPED_SQL_ID","MAPPED_HASH_VALUE","SQL_TRANSLATION_PROFILE_ID","CON_ID" from v$mapped_sql
View Text - HTML Formatted

SELECT "SQL_TEXT"
, "SQL_FULLTEXT"
, "SQL_ID"
, "HASH_VALUE"
, "MAPPED_SQL_TEXT"
, "MAPPED_SQL_FULLTEXT"
, "MAPPED_SQL_ID"
, "MAPPED_HASH_VALUE"
, "SQL_TRANSLATION_PROFILE_ID"
, "CON_ID"
FROM V$MAPPED_SQL