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