Thanks for all your help! Maxim's solution is great stuff and it will
take time for me to digest.

Our company uses Oracle 9.2 and features such as model I believe are
10g specific. Using SQL on Oracle 9i, I still find it very hard to
tackle the recursion in the problem. Hope you can give some insights
on this.

Thanks.

Nick Li

Thanks for all your help! Maxim's solution is great stuff and it will
take time for me to digest.

Our company uses Oracle 9.2 and features such as model I believe are
10g specific. Using SQL on Oracle 9i, I still find it very hard to
tackle the recursion in the problem. Hope you can give some insights
on this.

Thanks.

Nick Li

Thanks for all your help! Maxim's solution is great stuff and it will
take time for me to digest.

Our company uses Oracle 9.2 and features such as model I believe are
10g specific. Using SQL on Oracle 9i, I still find it very hard to
tackle the recursion in the problem. Hope you can give some insights
on this.

Thanks.

Nick Li