Nested IF conditions - Oracle SP
if(page='agreed')
then
IF (Act_Chk_Flag='CA') --admin has approved
THEN
FLAG_AS_YESNO := 'Yes';
else
FLAG_AS_YESNO := 'No';
END IF;
end if; --end page 'agreed'
then
IF (Act_Chk_Flag='CA') --admin has approved
THEN
FLAG_AS_YESNO := 'Yes';
else
FLAG_AS_YESNO := 'No';
END IF;
end if; --end page 'agreed'
Comments
Post a Comment