[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