Using Hirarical Tree To Display Data

markger helps me alot in this question
and i'm going to accept his answers
but before of that , i would like to get experts opinion about the following scenario
i have table for sales transactions consist of :
unit  number
catigory  number
sub_catigory number
item number
dob date
qty number
unit_price number
i would think to have data_block and display summary of sales like this scenario
using hirarecal tree to display units for each main node , and sales summary amount related to each node
then if user expand the node of any unit , it will display another levels of tree displaying catigories and sales amount for each catigory
then expand catigory to view sub_catigory & sales amount
then expand sub_catigory to view items and sales amount ,, etc
is it possible in oracle forms ?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GeerlingsDatabase AdministratorCommented:
Yes, Oracle Forms6i (and likely all later version of Oracle Forms) can support a "Hierachical Tree" object.  Are these a good idea to use in Oracle Forms?  Maybe, but maybe not.   Are they easy to design and use in Oracle Forms?  I would say no.  Are they the easiest way to display what you want to display in Oracle Forms.  In my opinion, no.  But, I admit, I never tried to develop a "Hierachical Tree" object in an Oracle Form.  I did have to use one that one of our developers created, and as a user of that form, I found it frustrating to work with.  Maybe that is just my experience.  Maybe other Oracle Forms developers and users like them.  I prefer the flexibility of queries that "normal" Oracle Forms database blocks support.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.