oracle 프로시저(procedure) 생성

CREATE OR REPLACE PROCEDURE TEST_PROCEDURE//프로시저명

IS exVar varchar2(100) := 'test111'; //변수명
BEGIN 

//실행할 query
     select cnt(*) from test1
COMMIT;   

END TEST_PROCEDURE;