select @pageTag(){
t.role_id, t.role_typ_code, a.typ_name, t.role_name, t.role_code
@}
from SYS_C_ROLE t, sys_c_role_typ a
where t.is_use = 'Y'
and t.role_name like #roleName#
and t.role_typ_code = a.typ_code(+)
and a.is_use(+) = 'Y'
@pageIgnoreTag(){
order by t.ord_by
@}