How To Find Reapeating Row Patterns

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Thu, 21 Jul 2005 13:26:03 -0500
Message-ID: <1F989681BA05FA4CAD9FA849ED8520578CEE3E@pscdalpexch01.perotsystems.net>

Anyone know of some examples of analytical procedures/functions/programs that will help me see patterns in repeating sequences of values?

This is for a application log table that may have dozens of messages in repeating orders, I want to try to isolate the message sequence for analysis.

For_Example

---

A
B
C
D
E
F
A
B
C
D
E
F

Something that would be able to see ABCDEF above. Even perhaps if a random X or Y was in the sequence, as long as it was infrequent it would be listed as an exeception.

Thanks!

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 21 2005 - 13:28:02 CDT