RE: FW: Extracting data based on foreign key relationships only

Are you looking for a script to extract the foreign keys, or a script to
extract the data?

-----Original Message-----
From: Israel Laureano Lazcano
[mailto:oracledba-ezmlmshield-x34871204.[Email address protected]
Sent: Sunday, March 30, 2008 7:42 PM
To: LazyDBA Discussion
Subject: Re: FW: Extracting data based on foreign key relationships only

As far as I know, there is no such popular method for doing this, but
it's not impossible to develop a SQL script or a PL/SQL function for
doing it.

Israel.

Ian Evans escribió:

>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.
>
>
>
>---------------------------------------------------------------------
>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
>
>
>
>
>
>

---------------------------------------------------------------------
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

Oracle LazyDBA home page