column owner format a20 column name format a30 column type format a20 select distinct owner,name,type from dba_source where owner like upper('&1') and upper(text) like upper('%&2%') order by owner,name,type;