You may want to use PL/SQL to achieve this update. Process your =
transaction
by grabbing your record in a cursor, accepting emp_no into a variable, =
then
execute your update by concatenating the variable to your constant =
('99').
Michael Armstead
> -----Original Message-----
> From: cyhu_at_eachnet.com [SMTP:cyhu_at_eachnet.com]
> Sent: Tuesday, July 25, 2000 7:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ??: HELP WITH UPDATE
>=20
>=20
> update emp set emp_no=3D'99'||sbustr(emp_no,3)
> -------------------------------
> Chunyu Hu=A3=ACDBA
> =BA=FA=B4=BA=D3=EA=A3=AC=CA=FD=BE=DD=BF=E2=B9=DC=C0=ED=D4=B1
> http://www.eachnet.com
> Tel(O)=A3=BA86-21-32174588*667
> E-mail=A3=BAcyhu_at_eachnet.com
> =
=C8=AB=B9=FA=C3=E2=B7=D1=B7=FE=CE=F1=C8=C8=CF=DF=A3=BA800-820-5217(=CE=D2=
=B0=AE=D2=D7=C8=A4)
>=20
> =A1=B0Eachnet.com - CHINA's LARGEST ON-LINE CONSUMER TRADING =
COMMUNITY
> =D2=D7=C8=A4=CD=F8 - =
=B8=F6=C8=CB=B5=E7=D7=D3=C9=CC=CE=F1=CE=AA=D6=D0=B9=FA=C8=CB=B4=B4=D4=EC=
=D5=B8=D0=C2=C9=FA=BB=EE=A1=B1
>=20
>=20
>=20
> =20
>=20
> "Suhen
>=20
> Pather" =CA=D5=BC=FE=C8=CB=A3=BA =
Multiple recipients
> of list ORACLE-L =20
> <pathers5_at_tel <ORACLE-L_at_fatcity.com>
>=20
> kom.co.za> =B3=AD=CB=CD=A3=BA
>=20
> =B7=A2=BC=FE=C8=CB=A3=BA =
=D6=F7=CC=E2=A3=BA HELP WITH UPDATE
>=20
> root_at_fatcity.
>=20
> com
>=20
> =20
>=20
> =20
>=20
> 00-07-25
>=20
> 06:54 PM
>=20
> =C7=EB=B4=F0=B8=B4 =B8=F8
>=20
> ORACLE-L
>=20
> =20
>=20
> =20
>=20
>=20
>=20
>=20
> Hi
>=20
> I have a table called EMP
>=20
> EMPNO NAME JOB
> 001 Scott DBA
> 002 Tiger DEV
> 003 King MAN
> ......
> 0010 Arthur PROG
>=20
>=20
> 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
>=20
> EMPNO NAME JOB
> 991 Scott DBA
> 992 Tiger DEV
> 993 King MAN
> ......
> 9910 Arthur PROG
>=20
> 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.
>=20
>=20
> TIA
> $uhen
>=20
> --
> 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).
>=20
>=20
> =02=EBa=A2=B2
> =
=1172=86=E7=9Ar=19=DE=B5=CA&=15=ABB=8A=DC=8Dz=DC(=AED=9E=AE=F8=9Cz=CF9=F3=
=9D=FC=E7Nu=14=05=FC=E7=CEw=F3=9D9=D5&=A7=0E'=A0=A0&=A5=89=FA+=9E&=8F=B9=
=B9bp=89=EDz=B9=DE=B5=A7=1Cz
> =CB?1=A8=A5=8Ax
> =
=8A=CBlN=84D0=E5D=CA=8B=AB=B1=E9_~=BA&=B6=18=AC=99=A8=A5=8Ax%=8A=CBlzwZ=9C=
C=1A=8AY=9E=B2=C6=A0z=DA=0B=8A=CBF=BA=BB=9Fj=D7"=B7'(=9Az-xE=C0 ;)zYb?
Received on Tue Jul 25 2000 - 08:31:47 CDT
