column profile format a20 column RESOURCE_NAME format a30 column LIMIT format a30 select * from dba_profiles where profile like upper('&1') order by profile,RESOURCE_NAME;