Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Change single digits to double digits.
Prince Of Thieves wrote:
> I want to change all single digits to double digits, eg. 1=>01, 2=>02, etc.
> The digits are in a TEXT field and there are some double digit and alpha in
> the same field.
>
> I tried the following syntax but got an error:
>
> UPDATE vmigrp SET clustcd = "0" & clustcd
> WHERE Length(clustcd)=1;
>
> And the error is "Var Parse Error" and another soon after "ORA-00933: SQL
> command not properly ended".
>
> Can this be done?
>
> --
>
> Julian Milano
>
>
UPDATE vmigrp SET clustcd = '0'||clustcd WHERE Length(clustcd)=1;
Check out --> tahiti.oracle.com. Received on Wed Oct 22 2003 - 17:55:19 CDT