DBA Data[Home] [Help]
Skip to content

VIEW: SYS.USER_LIBRARIES

Source

View Text - Preformatted

select LIBRARY_NAME, FILE_SPEC, DYNAMIC, STATUS, AGENT,
       LEAF_FILENAME, ORIGIN_CON_ID
from   NO_ROOT_SW_FOR_LOCAL(INT$DBA_LIBRARIES)
where  OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
View Text - HTML Formatted

SELECT LIBRARY_NAME
, FILE_SPEC
, DYNAMIC
, STATUS
, AGENT
, LEAF_FILENAME
, ORIGIN_CON_ID FROM NO_ROOT_SW_FOR_LOCAL(INT$DBA_LIBRARIES) WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')