DBA Data[Home] [Help]

VIEW: SYS.USER_IDENTIFIERS

Source

View Text - Preformatted

select NAME, SIGNATURE, TYPE, OBJECT_NAME, OBJECT_TYPE, USAGE,
       USAGE_ID, LINE, COL, USAGE_CONTEXT_ID, ORIGIN_CON_ID
from NO_ROOT_SW_FOR_LOCAL(INT$DBA_IDENTIFIERS)
where OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
View Text - HTML Formatted

SELECT NAME
, SIGNATURE
, TYPE
, OBJECT_NAME
, OBJECT_TYPE
, USAGE
, USAGE_ID
, LINE
, COL
, USAGE_CONTEXT_ID
, ORIGIN_CON_ID FROM NO_ROOT_SW_FOR_LOCAL(INT$DBA_IDENTIFIERS) WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')