Re: HELP WITH UPDATE

Hi

if empno is char Try with

   update emp set empno=replace(empno,'00','99')

if empno is number (this one i'm no tsure it works fine)

   update emp set empno=to_number( replace(to_char(empno),'00','99') )

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).
Received on Tue Jul 25 2000 - 05:40:28 CDT