Re: How to store a directory info into a database?

create dir as
dir_id number,
dir_name varchar2(100);

create dir_hierarchy as
dir_id varchar2(100),
parent_dir_id varchar2(100);

create dir_file as
dir_id varchar2(100),
file_name varchar2(100);

Use the "connect by" in a select command to traverse the dir_hierarchy to give U the directory tree.
EASY!!!, not like the others.

"Louis Chen" <llchen_at_nortelnetworks.com> wrote in message news:3CEE8978.E5B9B398_at_nortelnetworks.com...
> Hi, I need your suggestion as what would be an good design of a
> relational database to store a directory structure like information? I
> would be very appreciated if you could point to me any samples, website
> or books.
>
>
> Louis
Received on Sun May 26 2002 - 09:14:35 CDT