Brandon wrote:
> There's nothing wrong with what I'm doing with the data and the
> architecture is flawed.
>
> As I indicated earlier, the data is stored in two fields which I'm
> concatenating.
>
> Meaning it looks like the following:
>
> Participant_Id|Platform_Num|First_Name|Last_Name|Level8|Level9
> 1234|3877|John|Doe|94853,1,34843,2,128345,2,12834,4|47542,5,24852,7
> 1235|3877|Bob|Marley|94853,1,34843,2,128345,2,12834,4|47542,5,24852,7
> 1236|3877|John|Smith|94853,1,34843,2,128345,2,12834,4|47542,5,24852,7
>
> So, as you can see I have to concatenate level 8 and level 9 to get the
> full heiarchy and connect by doesn't work with data in the above
> format.
Perhaps I am misunderstanding your example but it seems the problem is
of your own creation due to the concatenation. Why are you concatenating
it rather than answering the question using the data as stored in the
table?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Aug 22 2006 - 17:29:36 CDT
