In oracle, this can be easily done.
The Fund table looks like:
FUND_NAME varchar2(25)
PARENT_FUND_NAME varchar2(25)
rest of the columns.........
And CONNECT BY PRIOR will give you the hierarchical structure.
Tamil
|
Results 1 to 2 of 2
Thread: Table Design SuggestionsThreaded View
|
Click Here to Expand Forum to Full Width |