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...
Exclamation points are needed because queries will often contain tables that contain fields with identical names
Indicate whether the statement is true or false
The Network Adapter History, in Task Manager, is primarily used to identify which network interface cards have been connected to the computer in the past
Indicate whether the statement is true or false
Flash allows you to reuse elements by creating ____, which you can copy and edit.
A. matrices B. commands C. symbols D. tools
Is the status bar Fit slide to current window button
Indicate whether the statement is true or false