Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview
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.
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