====== SCHEDULE ====== - 테이블생성 create table scott.tb_jobs ( log_dt date ); - procedure 생성 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; /