question on start with ... connect by prior syntax
443806Jan 5 2007 — edited Jan 24 2007I have a situation that represents a bill-of-material. It has three columns - downstream part, upstream part, quantity_per. For example, rows in it would be like this:
car chassis 1
car wheel 4
wheel tire 1
wheel nut 4
It is easy to extract an indented bill of material using the start with ... connect by prior... syntax.
I have a slightly more involved problem. I want to figure out that for a car, I need 16 nuts (i.e. at the leaf-level node). That is, I want to multiply and accumulate values of specific columns. Can this be done using the recursive SQL? I want to avoid having to write PL-SQL.
Thanks,
Regards,
Srini