[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')