Write a PL/SQL program to input hours and rate. Find gross pay and net pay. The tax rate is 28%. Print your results. (No need to perform overtime calculations)
What will be an ideal response?
```
SQL> SET VERIFY OFF
SQL> DECLARE
2 hours NUMBER(2) := &s_hours;
3 raTE NUMBER := &s_rate;
4 gross NUMBER;
5 taxrate NUMBER := 0.28;
6 net NUMBER;
7 BEGIN
8 gross := hours * rate;
9 net := gross - gross * taxrate;
10 DBMS_OUTPUT.PUT_LINE ('gross= $' || gross || ' and net= $' || net);
11 END;
12 /
Enter value for s_hours: 40
Enter value for s_rate: 10.50
gross= $420 and net= $302.4
PL/SQL procedure successfully completed.
```
You might also like to view...
Internet Message Access Mail Protocol works in a very similar way as which of the following?
A) POP3 B) UCE C) SMTP D) CSV
Criminal statutes define crimes in terms of required acts and a required state of mind, typically referred to as
A) The person's motivation B) The person's psychological makeup C) The person's intent D) The person's needs at the time