This script allows an ID to be entered and it will display the related ASCII characters. Used to check for bad names.
set serveroutput on
declare
v_id varchar2(9) := '1329455';
v_name varchar2(200);
v_i number(4);
begin
select spriden_last_name||' '||spriden_first_name||' '||spriden_mi
into v_name
from spriden
where spriden_id = v_id
and spriden_change_ind is null;
for v_i in 1..length(v_name) loop
dbms_output.put_line(v_i||' '||substr(v_name,v_i,1)||' '||ascii(substr(v_name,v_i,1)));
end loop;
end;
/