16 lines
282 B
SQL
16 lines
282 B
SQL
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')
|
|
/
|