RE: How To Find Reapeating Row Patterns
- To: <Ethan.Post@xxxxxx>, "sol beach" <sol.beach@xxxxxxxxx>
- Date: Fri, 22 Jul 2005 13:23:16 -0400
Ethan
What constitutes a pattern? What makes it a success?
Does A,A; AB,AB; ABC,ABC; ABCD,ABCGD?
How about A, followed by 1000 other records and then A again?
Seems to me the rules need to be defined a little better. I get the
feeling that this is a science all in itself. I wonder if regular
expressions could help here.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Post, Ethan
Sent: Friday, July 22, 2005 1:17 PM
To: sol beach
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: How To Find Reapeating Row Patterns
yes, this is a log table, there is a time stamp.
-----Original Message-----
From: sol beach [mailto:sol.beach@xxxxxxxxx]
Sent: Friday, July 22, 2005 12:15 PM
To: Post, Ethan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: How To Find Reapeating Row Patterns
If each line below is supposed to be a separate record in a table,
please keep in mind that in any RDBMS the order in which rows are
returned
is indeterminate, unless ORDER BY clause is specified on the SELECT!
On 7/21/05, Post, Ethan <Ethan.Post@xxxxxx> wrote:
[...snip...]
>
> For_Example
> ====================
> A
> B
> C
> D
> E
> F
> A
> B
> C
> D
> E
> F
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
