Topic: Prompting Hierarchy
Not finding your answer? Try searching the web for Prompting Hierarchy
Answers to Common Questions
How to Prompt and Hard Code Date Range In Hierarchy Query?
I just realized this is Oracle... I think this will work. declare dtVal DATE; select root, max(decode(cat_level,1,description)) level1, count(*) from ( select description, root, row_number() over (partition by... Read More »
Source: http://www.experts-exchange.com/Q_21870426.htm
