Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can Oracle save a tree?
The company I work for makes reports for other companies, based
on geography, states, districts, etc. and the companies can vary
from a one location shop, to a multinational with thousands of
branch offices.
Needless to say, the most natural way to store this is in a tree data structure. I have already done that at the Java-GUI front end, but I was wondering how to do it in the database.
I realize that anything can be flattened to a relational table, but I understand that now Oracle has other non-traditional ways of storing data.
So, is it possible to save a tree in Oracle?
TIA, -Ramon F. Herrera Received on Tue Apr 27 2004 - 21:13:38 CDT