Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle SQL help
If this is 10g, look into the documentation on regular expression functions. They will be able to do what you want.
Pat
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bala
Sent: Thursday, June 28, 2007 4: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
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 28 2007 - 17:14:52 CDT
![]() |
![]() |