oracle update statement

anumoses
anumoses used Ask the Experts™
on
select scale_weight
from qc_scale_weights
where scale_weight like 'DR%'

SCALE_WEIGHT
DR009
DR010
DR011
DR012
DR013
DR014
DR015
DR016
DR017
DR018
DR019
DR020
DR021
DR022
DR023
DR024
DR025
DR026
DR027
DR028
DR001
DR002
DR003
DR004
DR005
DR006
DR007
------------------
Need to update DR with DRCSWGT001, .... 002 etc
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Try this:

update qc_scale_weights set scale_weight = replace(scale_weight,'DR','DRCSWGT)
where scale_weight like 'DR%'

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial