DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_SERVICE_NAME

Source

View Text - Preformatted

select dbid, service_name_hash, service_name,
       decode(con_dbid, 0, dbid, con_dbid),
       con_dbid_to_id(decode(con_dbid, 0, dbid, con_dbid)) con_id
  from WRH$_SERVICE_NAME sn
View Text - HTML Formatted

SELECT DBID
, SERVICE_NAME_HASH
, SERVICE_NAME
, DECODE(CON_DBID
, 0
, DBID
, CON_DBID)
, CON_DBID_TO_ID(DECODE(CON_DBID
, 0
, DBID
, CON_DBID)) CON_ID
FROM WRH$_SERVICE_NAME SN