Re: Compare CLOB's and hilite difference

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Mon, 30 Mar 2009 11:52:24 +0100
Message-ID: <486b2b610903300352j643a954cj51d0de67fa95e625_at_mail.gmail.com>



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

Cheers

Stefan


Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch


On Sat, Mar 28, 2009 at 3:59 PM, Bill Ferguson <wbfergus_at_gmail.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 30 2009 - 05:52:24 CDT

Original text of this message