Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I update part of a field's value in SQL
You might consider writing a small stored procedure that accepts the old and new names (or portions of them) as parameters and then makes the changes using the pl/sql string manipulation functions.
A cursor could be opened against the old name with a wildcard (%) appended, you then get the old length (or new length) and use this to trim and recreate the string and then update it back in.
--
-cheers
DW
Sent via Deja.com
http://www.deja.com/
Received on Tue Jan 09 2001 - 10:47:48 CST