CREATE OR REPLACE PROCEDURE SCOTT.SP_INSERT_LOG_DATE
IS
BEGIN
INSERT INTO SCOTT.TB_JOBS (LOG_DT) VALUES (SYSDATE);
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END SP_INSERT_LOG_DATE;
/
dbms/oracle/admin/schedule/01.txt · 마지막으로 수정됨: 2015/06/21 01:14 저자 starlits