Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> HELP WITH UPDATE

HELP WITH UPDATE

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Tue, 25 Jul 2000 11:45:28 +0200
Message-Id: <10569.112841@fatcity.com> 





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.
Received on Tue Jul 25 2000 - 04:45:28 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US