Amanullah Amanullahgit
🏠
Amanullahgit
/ explicit_cursor_example.sql
Created
September 27, 2020 06:16
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
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 |