1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
chaine1_car1 := substr(chaine1,1,1);
chaine1_car2 := substr(chaine1,2,1);
chaine1_car3 := substr(chaine2,3,1);
chaine1_car4 := substr(chaine2,4,1);
chaine2_car1 := substr(chaine2,1,1);
chaine2_car2 := substr(chaine2,2,1);
chaine2_car3 := substr(chaine2,3,1);
chaine2_car4 := substr(chaine2,4,1);
etc...
IF chaine1_car2 <> chaine2_car2 then
IF chaine2_car2 = '*' then
v_reponse := 'TRUE';
else
if chaine2_car4 <> '*' and chaine2_car1 <> chaine1_car1 then
v_reponse := 'False';
end if;
End if; |
Partager