Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to store a directory info into a database?
It will not have a fixed number of table, that is true, but it is not
difficult to handle. The interfacing program will just have to use its
metadata method to see how many tables there are in it; other than that
incremental change all the tables are the same.
ejd
"Louis Chen" <
> Thanks for your kind suggestions. But my immediate thought was that it
> would be very difficult the program interfacing to the database as the
> schema is not fixed, it changs dynamically.
>
>
> Louis
>
> Eric Dickner wrote:
> > How about this.
> >
> > table level_0 {
> > dir_id int, KEY
> > dir_name varchar,
> > parent_id int = null,
> > child_id enumeration of int,
> > }
> >
> > table level_1 {
> > dir_id int, KEY
> > dir_name varchar,
> > parent_id int = null,
> > child_id enumeration of int,
> > }
> > .
> > .
> > .
> > table level_N {
> > dir_id int, KEY
> > dir_name varchar,
> > parent_id int = null,
> > child_id enumeration ot int,
> > }
> >
> > I have to think this is the best you can do both search wise and
sroarage
> > wise.
> >
> > ejd
Received on Tue May 28 2002 - 07:38:47 CDT