Thought I would send this out again for a try, had no replies on it.
-----Original Message-----
From: Ian Evans
[mailto:oracledba-ezmlmshield-x34941643.[Email address protected]
Sent: Thursday, 13 March 2008 1:13 PM
To: LazyDBA Discussion
Subject: Extracting data based on foreign key relationships only
Is there a popular method or sql script somewhere that I can use to pull
data from a schema that has a significant relationship structure using
just foreign keys?
Obviously I have a parent table populated and data is connected
downstream via an extensive relationship of foreign keys. If I can
tease out one thread at a time and collect and cascade of rows that
would be useful.
I guess it's a bit like using the cascade delete "function" but for read
purposes.
I know third party products can be configured to do this, but thought
there may be some good work done by DBAs or Oracle that may have been
published for common use.
Thanks in advance, Ian Evans.
Notice:
This e-mail and any attachments are confidential
and may contain legally privileged information
and/or copyright material of Hansen Technologies
Limited or third parties. Copying, distributing,
disclosing, commercialising or otherwise acting in
reliance on this e-mail and any attachments is
strictly prohibited unless you are the addressee of
this e-mail and have written permission to do so. If
you have received this e-mail in error please
delete this e-mail (including any copies and
attachments) and contact Hansen Technologies
Limited by return e-mail or by telephone on + 61 3
9840 3000. Any views expressed in this e-mail are
those of the individual sender and may not
necessarily reflect the views of or be a
commitment by the organisation, except where the
individual sender has the authority and expressly
states them to be so.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Notice:
This e-mail and any attachments are confidential
and may contain legally privileged information
and/or copyright material of Hansen Technologies
Limited or third parties. Copying, distributing,
disclosing, commercialising or otherwise acting in
reliance on this e-mail and any attachments is
strictly prohibited unless you are the addressee of
this e-mail and have written permission to do so. If
you have received this e-mail in error please
delete this e-mail (including any copies and
attachments) and contact Hansen Technologies
Limited by return e-mail or by telephone on + 61 3
9840 3000. Any views expressed in this e-mail are
those of the individual sender and may not
necessarily reflect the views of or be a
commitment by the organisation, except where the
individual sender has the authority and expressly
states them to be so.
Oracle LazyDBA home page