## Minimizing the number of SQL update statements

    UPDATE ACCOUNT
    SET ACC_DESC = 'CONSULTING SERVICES' ;

    UPDATE ACCOUNT
    SET CATEGORY = 'INCOME' ;


    UPDATE ACCOUNT  A
    SET  ( ACC_DESC,
           CATEGORY ) = ( SELECT ACC_DESC, CATEGORY
                          FROM   INPUT_TABLE I
                          WHERE  A.ACC_NO = I.ACC_NO
                        )
    WHERE  EXISTS       ( SELECT 'X'
                          FROM   INPUT_TABLE I
                          WHERE  A.ACC_NO = I.ACC_NO );
