pl/sql

CREATE OR REPLACE PROCEDURE INCR
(SAL IN OUT NUMBER)
IS
BEGIN
SAL:= SAL+2000;
END;

DECLARE
SALARY NUMBER(5);
BEGIN
SALARY:= :ENTER_SALARY;
INCR(SALARY);
DBMS_OUTPUT.PUT_LINE('THE UPDATED SALARY IS' || SALARY);
END;

Comments

Popular Posts