Showing posts from September, 2025
/************Insert Data into Table*************/ declare v_has_error BOOLEAN := FALSE; begin FOR R1 IN ( SELECT COL.c001 AS SOLD_TO_CUSTOMER_ID, COL.c002 AS GROUP_CODE, COL.c003 AS…
Toad -Schedule Job Create Go to Schedule Job: 1. Basic Info: Write your Job Name: 2. Schedule Info: Click the Mouse Right Button à Select Now Select the Time schedule for the run. 1. 3 . Program Info: At first, creat…