函数实现

CREATE OR REPLACE
FUNCTION compair_str
(
para1 in VARCHAR2,
para2 in VARCHAR2)
return int
as
begin
if length(para1) <> length(para2) then
return 0;
else
for i in 1…length(para1)
loop
if ascii(substr(para1, i, 1))<>ascii(substr(para2, i, 1)) then
return 0;
end if;
end loop;
return 1;
end if;
end compair_str;

select compair_str(‘汤姆A’,‘汤姆A’);–1
select compair_str(‘汤姆A’,‘汤姆a’);–0
select compair_str(‘abc’,‘aaa’);–0
select compair_str(‘abc’,‘ABCC’);–0
select compair_str(‘abc’,‘ABC’);–0
select compair_str(‘abc’,‘abc’);–1