17,382
社区成员




create or replace function isNumber(p_in varchar2) return boolean as
i number;
begin
i:=to_number(p_in);
return true;
exception
when others then
return false;
end ;
with t as(
select 1001 id,'1000'num,'1002 ' name from dual
union all select 1002,'1001','1003 ' from dual
union all select 1003,'1002','1004 ' from dual
union all select 1004,'1003','1005 ' from dual
)
--select a.* from t a,t b where a.id=b.num;
select a.* from t a,t b where a.id=b.name;