DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_SQLCOMMAND_NAME

Source

View Text - Preformatted

select dbid, command_type, command_name,
       decode(con_dbid, 0, dbid, con_dbid),
       0 con_id
from WRH$_SQLCOMMAND_NAME
View Text - HTML Formatted

SELECT DBID
, COMMAND_TYPE
, COMMAND_NAME
, DECODE(CON_DBID
, 0
, DBID
, CON_DBID)
, 0 CON_ID FROM WRH$_SQLCOMMAND_NAME