set verify off

break on profile skip page on resource_type skip 1
SELECT profile, resource_type, resource_name, limit
FROM dba_profiles
WHERE profile like upper('%&&1.%')
ORDER BY profile, resource_type
/

break on profile skip 1
SELECT profile, username
FROM dba_users WHERE profile like upper('%&&1.%')
ORDER BY profile
/

undefine 1
clear break

set verify on

hostgator