oracle8.0 SELECT role_id FROM pm_roles WHERE rownum = 1 SELECT one_line || ' (' || substr(one_line,1,1) || ')' as one_line, role_id FROM pm_roles ORDER BY role_id