RE: Oracle SQL help

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 29 2007 - 06:20:49 CDT