update column

[hammam02]

hi dear

if i have 2 columns include 900 record

like that

EL_AMAL007 ATM007
WATER C008 ATM008
VACSERA009 ATM009
VACSERA010 ATM010
EBICO 011 ATM011
TAKI VI012 ATM012
IMBABA 013 ATM013


and i need to update column 1 by last 3 degit of column 2

to became

007 ATM007
008 ATM008
009 ATM009
010 ATM010
011 ATM011
012 ATM012
013 ATM013

 

[LKBrwnDBA]

And what is preventing you from doing it?

If you need a hint, use the SUBSTR() function in the update statement.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

Hammam02

?? ????? ?????????? ? ????? ?? "Hi Dear" ?????? ?? ??????.




Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”