update by cursor in oracle

 DECLARE 

   CURSOR CUR

   IS   

SELECT CREATORS_REFERENCE ORDER_NO, MIN(INVOICE_ID) INVOICE_ID

    FROM IFSAPP.CUST_ORDER_INV_HEAD_UIV_ALL@PROD I

    WHERE  I.CREATORS_REFERENCE IN (SELECT ORDER_NO FROM DIFF_HAPS_IFS_TAB WHERE CREATORS_REFERENCE=ORDER_NO)

    GROUP BY CREATORS_REFERENCE;

BEGIN

   FOR REC IN CUR

   LOOP

      UPDATE DIFF_HAPS_IFS_TAB SET INVOICE_ID=REC.INVOICE_ID

      WHERE ORDER_NO=REC.ORDER_NO;

   END LOOP;

   COMMIT;

END;

/

Scheduler in all

--OS Scheduler--

Windows

reportdb/r@reportdb @"D:\Schedule Query\IAL_C_COWISE_CUSTOMER_INFO.sql"

New Add Multiple scheduler time

Linux

--DB Scheduler--

Oracle

Sql Server

Date format

 select  ADD_MONTHS(TRUNC(SYSDATE,'MM'),-1), last_day(add_months(trunc(sysdate,'mm'),-1))-- , TRUNC(LAST_DAY (SYSDATE - 1))

from DUAL