| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP WITH UPDATE
My solution is if u want to convert 0001 to 9900
or 0089 to 9989.
-----Original Message-----
From: Kamesh J. Mantri
Sent: Tuesday,July 25, 2000 6:05 PM
To: 'pathers5'; 'ORACLE-L'
Subject: RE: HELP WITH UPDATE
Hi,
U can also do like this in a very simple way.
if empno is a number then u can say
update emp set empno = empno + 9900 where empno >= 0 and empno <100;
if empno is (var)char then u can say
update emp set empno = to_char(to_number(rtrim(empno)) + 9900) where empno like '00%';
Kamesh.
Citicorp Overseas Software Ltd,
Chennai,India.
-----Original Message-----
From: pathers5 [mailto:pathers5_at_telkom.co.za]
Sent: Tuesday,July 25, 2000 4:24 PM
To: ORACLE-L
Cc: pathers5
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 Liststo: 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 Received on Tue Jul 25 2000 - 07:43:02 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |