RE: HELP WITH UPDATE

Hi,

wouldn't it be something like :

update table emp set empno = '99'||substr(empno,3) ;

assuming it is a (var)char and every entry starts with '00' ...

Greets,

Kirsten

> -----Original Message-----
> From: Suhen Pather [SMTP:pathers5_at_telkom.co.za]
> Sent: Tuesday, July 25, 2000 11:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: HELP WITH UPDATE
>
> 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 - 06:32:42 CDT