Oracle SQL help

From: Bala <oratips@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 28 Jun 2007 17:29:03 -0400

--
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

Follow-Ups:

RE: Oracle SQL help
From: Elliott, Patrick

Re: Oracle SQL help
From: Bala

RE: Oracle SQL help
From: Mercadante, Thomas F (LABOR)

Other related posts:

Browse oracle-l