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.

 

 

 

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-paand table named as emp-gross,