Re: Linking records together

From: Malcolm Dew-Jones <>
Date: 23 Sep 2009 15:05:21 -0700
Message-ID: <4aba9ba1$>

PJ ( wrote:
: Hi all,

: We need to track work items across several existing applications. Items can
: start as a document on disk, can be renamed or moved, converted to a task
: in an application, until they reach a certain state. The applications know
: nothing about preceding or following applications and there is no common
: identifier for the items, which has always been a good thing.

: My idea is to create a table for all events. Each application will record
: their
: own events. A minimum is one event per application with a starting and
: finishing situation for that application. Example: "file \\folder1\x.doc was
: moved to \\folder2\y.doc". Another application may follow up with
: "\\folder2\y.doc was archived with id 12345". Each event will have a date
: and time.

Use connect by to join the entries and sys_connect_by_path to show each complete path.

You will get extra entries such as


Filter that list so you only see the results where the end (e.g. X) does not have a next connection.

CONNECT_BY_ISLEAF might help do that.

CONNECT_BY_ROOT might be useful when displaying the end points.

sys_connect_by_path might not even be required here. Received on Wed Sep 23 2009 - 17:05:21 CDT

Original text of this message