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'

Comments

Popular Posts