Re: HELP WITH UPDATE

update emp
set empno='99'||substr(empno,2)
where empno like '00%'
;

Suhen Pather wrote:

> Hi
>
> I have a table called EMP
>
> EMPNO NAME JOB
> 001 Scott DBA
> 002 Tiger DEV
> 003 King MAN
> ......
> 0010 Arthur PROG
>
> If I need to update the column EMPNO and change all the values in the beginning from 00 to 99.
> So the table will look like
>
> EMPNO NAME JOB
> 991 Scott DBA
> 992 Tiger DEV
> 993 King MAN
> ......
> 9910 Arthur PROG
>
> How can I update the table EMP's column EMPNO and change all the values from 00 to 99 in one go without doing each update manually.
>
> TIA
> $uhen
>
> --
> Author: Suhen Pather
> INET: pathers5_at_telkom.co.za
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Rustem Valeev, valeev_at_avicomp.ru, (095)4360496