Wednesday 11 January 2012

UPDATE_MORE_THEN_ONE_COLUMN_IN_TABLE

/* Formatted on 1/11/2012 10:31:11 PM (QP5 v5.115.810.9015) */
UPDATE   XX_AP_CHECKS_11I_R12
   SET   R12_CURRENCY_CODE = NULL,
         R12_OPERATING_UNIT = NULL,
         R12_CHECK_ID = NULL,
         R12_VENDOR_NAME = NULL,
         R12_VENDOR_SITE_CODE = NULL,
         R12_CHECK_NUMBER = NULL,
         R12_CHECK_DATE = NULL,
         R12_CHECK_AMOUNT = NULL,
         R12_BANK_ACCT_NAME = NULL,
         NO_OF_REC = NULL,
         COUNT_OF_INVOICES = NULL,
         STATUS = NULL                    --WHERE R12_CURRENCY_CODE LIKE 'R12'

No comments:

Post a Comment