Yurttas/PL/DBL/oracle/F/02/Movie/profit.sp

From ZCubes Wiki
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/