Yurttas/PL/DBL/oracle/F/02/Movie/profit.sp
Jump to navigation
Jump to search
1REM
2REM
3REM profit.sp
4REM
5REM
6
7CREATE OR REPLACE
8PROCEDURE Profit(gross IN NUMBER,
9 budget IN NUMBER) IS
10
11 profit NUMBER;
12
13BEGIN
14
15 profit := budget - gross;
16
17 DBMS_OUTPUT.PUT_LINE('Profit is : ' || profit);
18
19END Profit;
20/