Re: Compare CLOB's and hilite difference

From: Stefan Knecht <>
Date: Mon, 30 Mar 2009 11:52:24 +0100
Message-ID: <>

Oracle Text has a highlight functionality. It might just do what you need.



Stefan P Knecht
CEO & Founder

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27

On Sat, Mar 28, 2009 at 3:59 PM, Bill Ferguson <> wrote:

> Does anybody have any code they could share that compares two CLOB's
> and hilites the differences?
> My app stores a 'history' of the entire record (with all sub-table
> data) in an XML-typ CLOB field. I'd like to be able to do something
> similar to Wikipedia, where the users select two records to compare,
> and have the differences hilited.
> The CLOB's are stored in the same table, along with other info, i.e.
> userid, timestamp, dep_id (the tie to the master record), and a
> sequence I use for the PK in this table. Each line in the CLOB is
> terminated with a CHR(10).
> The CLOBS are usually around 68K each, and I'm having a devil of a
> time looping around through each CLOB and comparing the results on
> those that are over 32K in size.
> I realize the above is really basic, so more info can be provided if
> needed. I started with just a procedure, but that quickly became
> extremely difficult to follow, so I started on trying to rewrite into
> a package. Then I figured I might as well see if somebody has already
> 'invented' something similar so I didn't have to reinvent the wheel.
> Thanks.
> --
> -- Bill Ferguson
> --

Received on Mon Mar 30 2009 - 05:52:24 CDT

Original text of this message