Search and Replace Using SQL Oracle i9

Wrox Programmer Forums

		Wrox Programmer Forums > PHP/MySQL > Beginning PHP
Search and Replace Using SQL Oracle i9

Beginning PHP Beginning-level PHP discussions. More advanced coders should post to the Pro PHP forum.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning PHP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

April 17th, 2007, 11:01 AM

Corey

Corey is offline

Friend of Wrox

Join Date: Sep 2005

Posts: 106

Thanks: 0

Thanked 0 Times in 0 Posts

Send a message via Yahoo to Corey

Default

Search and Replace Using SQL Oracle i9

Can anyone show me a easy way to do a find and replace using SQL Oracle i9

Example
Select row1
From table1
Find â123â
Replace with âABC

Thank you for your help

Old

April 28th, 2007, 09:58 AM

Greg Griffiths Greg Griffiths is offline

Greg Griffiths is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 344

Thanks: 0

Thanked 1 Time in 1 Post

Default

a quick Google shows sites such as http://www.techonthenet.com/oracle/f...ns/replace.php which cover this, so something like :

update table1 set row1=replace(row1,'123','ABC')

should work

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search and Replace a text in XML file	AyatKh	XML	17	May 23rd, 2012 09:05 PM
Global Search&Replace Text in all fields in sql db	buddyz	SQL Server 2000	10	September 14th, 2006 08:24 AM
Need help with a search,convert and replace	mhkay	XSLT	1	February 23rd, 2005 05:09 PM
Need help with a search,convert and replace	dhollis	XSLT	4	February 23rd, 2005 03:26 PM
RTF Search & Replace	PC User	Access	0	June 16th, 2004 01:46 PM