Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- id NUMBER;
- gaji NUMBER;
- tgl DATE;
- lama NUMBER;
- bonus NUMBER;
- BEGIN
- id := &e_id;
- gaji := &g;
- tgl := &tg;
- lama := ROUND((SYSDATE-tgl)/365);
- IF lama > 20 AND gaji < 20000 THEN
- bonus := 0.05 * gaji;
- ELSIF lama > 20 AND gaji > 20000 THEN
- bonus := 0.01 * gaji;
- ELSIF lama < 20 AND gaji < 15000 THEN
- bonus := 0.1 * gaji;
- ELSIF lama < 20 AND gaji > 15000 THEN
- bonus := 0.07 * gaji;
- ELSE bonus := 0.02 * gaji;
- END IF;
- DBMS_OUTPUT.PUT_LINE('Hasil : ' || bonus);
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement