the employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id &contribution_amount If employee salary is in between $1000-$3999 And if employee's contribution amount is less than $100 then company match $100 if employee's contribution amount is greater than 100 but less than $200 then company match $75 if employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if employee's contribution amount is less than $100 then company match $150
the employee table have the following .
ask user what is the employee_id and how much employee wants to contribute
2 substitutions variable from end user
&emp_id
&contribution_amount
If employee salary is in between
$1000-$3999
And if employee's contribution amount is less than $100 then company match $100
if employee's contribution amount is greater than 100 but less than $200 then company match $75
if employee's contribution amount is greater than $200 then company match $50
$4000-$6999
And if employee's contribution amount is less than $100 then company match $150
if employee's contribution amount is greater than 100 but less than $200 then company match $100
if employee's contribution amount is greater than $200 then company match $75
$7000-$12000
And if employee's contribution amount is less than $100 then company match $200
if employee's contribution amount is greater than 100 but less than $200 then company match $125
if employee's contribution amount is greater than $200 then company match $100
>$12,000
Whatever employee's contribution amount is company will match only %50 of contribution amount
Create a PL/SQL block using nested IF statements to accomplish the task. Input values for
the block are &employee_id and &contribution_amount.
Step by step
Solved in 2 steps with 6 images
