How to create a procedure in oracle using SQL developer

--

CREATE TABLE WAREHOUSE_LEVEL 
(
    ID INT  
  , QTY_MIN VARCHAR2(5)
  , QTY_MAX VARCHAR2(5)
  , WHS_AUTO_KEY VARCHAR2(5)
);

INSERT INTO WAREHOUSE_LEVEL VALUES ( 1,'2','1','31' );

CREATE OR REPLACE Procedure BALOKAD_PROC_WHRSE_MIN_MAX_31
IS
BEGIN
  
   UPDATE WAREHOUSE_LEVEL SET QTY_MIN = '0', QTY_MAX = '0' WHERE WHS_AUTO_KEY = '31';
   COMMIT;
 
END;\\

begin
BALOKAD_PROC_WHRSE_MIN_MAX_31;
end;\\

--

Select allOpen in new window

--

select * from WAREHOUSE_LEVEL\\


--

Select allOpen in new window

--

/*------------------------
OUTPUT
------------------------*/
ID          QTY_MIN     QTY_MAX     WHS_AUTO_KEY
----------- ----------- ----------- ------------
1           0           0           31

--

Select allOpen in new window