19 lines
461 B
SQL
19 lines
461 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
col lib_owner head OWNER for a25
|
|
col lib_file_spec head FILE_SPEC for a80
|
|
|
|
select
|
|
owner lib_owner,
|
|
library_name,
|
|
dynamic dyn,
|
|
status,
|
|
file_spec lib_file_spec
|
|
from
|
|
dba_libraries
|
|
where
|
|
lower(library_name) like lower ('&1')
|
|
or lower(file_spec) like lower ('&1')
|
|
/
|