Re: HELP WITH UPDATE

Update EMP set EMPNO =3D 99||SUBSTR(EMPNO,3)

Ron Rogers
DBA
Atl.GA
>>> pathers5_at_telkom.co.za 07/25/00 06:54AM >>>
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=20

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).