This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/*** | |
Write a PLSQL block using explicit cursor to calculate the gross salary for every employee from EMP table using following formula: | |
Gross_salary=salary+(DA+HRA+TA) – TAX | |
DA is 60% of salary | |
HRA is 20% of salary | |
TA is fix at 2000 | |
TAX is 5% of salary | |
***/ | |
SET SERVEROUTPUT ON | |
DECLARE |