Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

/ Home / Computer & Internet / Oracle SQL, PLSQL, APEX How To's

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

If < some condition>

then < some condition >

end if;

< some condition>

end if;

18.02 How to use nested if conditions

For example :

if level = 'Executive' then if pay >= 60000 then

dear-allowance := 0,50 --- assignment of percentage

end if;

else