用to_number 写个函数来处理.
create or replace function test_dinya(p_in varchar2) return varchar2 as
p_out varchar2(1):='N';
i number;
begin
i:=to_number(p_in);
return 'Y';
exception
when others then
return 'N';
end ;
select test_dinya('#0665') from dual --返回N
select test_dinya('0665') from dual --返回Y