Re: Heiarchial Data in a SINGLE column

Brandon wrote:
> Good day all,
>
> I'm working in an environment where our data architecture leaves quite
> a bit to be desired. Our systems were built upon a somewhat shaky
> foundation, which sometimes takes us a lot of time to create work
> arounds.
>
> The current issue is this:
>
> We have employee heiarchial information stored in two columns in our
> user table (field8 and field 9).
>
> I concatenate that data into one field. The data looks like the
> following:
>
> 83661,7,134123,6,84311,4,80896,3,60849,2,28626,218339,2,13588,2,03093,2,01785,1,,0,,0,,0,,0,01202,1
> ^^^
> <<userId,supervisor_level,userId,supervisor_level>>

What is the point of concatenation?

I don't see anything wrong with the architecture. I see something wrong with what you are doing with it.

Leave the data alone and look at the syntax of CONNECT BY. Syntax at http://tahiti.oracle.com
Demos in Morgan's Library at www.psoug.org

-- 
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