oracle8.0 SELECT one_line as role, substr(one_line,1,1) as abbreviation FROM pm_roles