RE: Oracle SQL help

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <oratips@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Jun 2007 07:20:49 -0400

Bala,

 

You can try:

 

Update table

  Set column_name = substr(column_name,1,instr(column_name,':',1)-1) ||
'9999999999')

Where {anything}

 

Tom

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bala
Sent: Thursday, June 28, 2007 5:29 PM
To: oracle-l
Subject: Oracle SQL help

 

 

-- 
Want to update a column of a table with 150,000 rows

columns values are like "JOHN THOMPSON:0011442717"

Want to change the numeric value after ":" of each row to a 10 digit
constant numeric 9999999999 for all 150,000 rows
--

Thanks for all ideas and help.

-- 
Bala Rao 

Other related posts: