No Linebreak for small SQL < 10 chars
IF credit >= debit THEN
UPDATE customeraccount
SET balance = balance - debit_amount
WHERE account_id = 100400;
ELSE
UPDATE customeraccount
SET balance = balance + debit_amount
WHERE account_id = 100400;
END;
No Linebreak for small SQL < 100 chars
IF credit >= debit THEN
UPDATE customeraccount SET balance = balance - debit_amount WHERE account_id = 100400;
ELSE
UPDATE customeraccount SET balance = balance + debit_amount WHERE account_id = 100400;
END;
Edited 2 time(s). Last edit at 03/31/2009 10:11AM by guidomarcel.
