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…