Advertisement

06.11.2007 at 11:29AM PDT, ID: 22626645
[x]
Attachment Details

finding substring

Asked by jagadeesh_motamarri in Oracle 9.x, Oracle Database, Oracle 10.x

Tags: substring, oracle, finding, replace

Hi guys -

One of my table columns in an oracle database is a clob datatype and actually contains xml data.

I need to write a query  to find out all the rows that contain "$nbsp;" in that columns text and then replace all those rows with "$amp;nbsp;" .

How do i do this in oracle.

Thanks -
JMStart Free Trial
[+][-]06.11.2007 at 11:55AM PDT, ID: 19260566

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.11.2007 at 10:33PM PDT, ID: 19263837

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.11.2007 at 11:35PM PDT, ID: 19264024

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 05:33AM PDT, ID: 19265466

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 9.x, Oracle Database, Oracle 10.x
Tags: substring, oracle, finding, replace
Sign Up Now!
Solution Provided By: tranz435
Participating Experts: 3
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32