Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: HELP WITH UPDATE
Hai Pather,
Yes , you can update
See the following command
Update emp set empno ='99'||substr(empno,3,4) ;
Regards.
Sul.
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:28:58 CDT
![]() |
![]() |