WELCOME to JF's ZONE

CREATE OR REPLACE PROCEDURE TOTAL(HARGA IN INTEGER, DISKON INTEGER,
                                    TOTAL_BELI IN INTEGER)AS
                                   
BEGIN
IF TOTAL_BELI := (HARGA>=170000)THEN
    DISKON := TOTAL_BELI * 0.1
ELSIF TOTAL_BELI := (HARGA>=50000 AND HARGA<=170000)THEN
    DISKON := TOTAL_BELI * 0.01
ELSE
    DISKON := TOTAL_BELI * 1
END;
/

PROCEDURE CREATE

SET SERVER OUTPUT ON
DECLARE
TOTAL INTEGER
BEGIN
TOTAL (1800000)
DBMS.OUTPUT.PUT_LINE('TOTAL BELI' | TOTAL);
END;
/