Re: Length of Bank Account Numbers

[George Jansen <GJANSEN@AFLCIO.ORG>]

I understand management's aversion to last minute change, but most
people regard change as a good thing when it is from non-working to
working.

If you must--and you are prepared to live with the consequences
forever--you could hang an insert trigger on your table, accompanied
perhaps by a check constraint:

CREATE OR REPLACE TRIGGER gee_i_dont_wanna_do_this
  AFTER INSERT OR UPDATE OF (account_ec_id) ON ps_src_bank
  FOR EACH ROW
BEGIN
    :NEW.account_ec_id := rpad(:NEW.account_ec_id,12,' ');
END gee_I_dont_wanna_do_this;
/