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.
dear-allowance := 0,65 --- assignment of percentage
end if;
Usage of cursor and if conditions, we shall write a PLlSQL Block and see the results,
We have emp-id (employee Identification Number), basic-pay in table called emp-pay, In another table, emp-id, gross-pay and table named as emp-gross,