Re: Oracle SQL help

How about something like this:

update table
set column = substr(column,0,instr(column,':')) || ':9999999999'

or something like that. First, do a:

select substr(column,0,instr(column,':')) || ':9999999999' from table;

to make sure I got the syntax right--I haven't checked it. Once you get it right, plug it in, check it and, if it's right, commit it.

Dan

• Original Message ---- From: Bala <oratips_at_gmail.com> To: oracle-l <oracle-l_at_freelists.org> Sent: Thursday, June 28, 2007 4:29:03 PM 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 Thu Jun 28 2007 - 16:55:32 CDT