Actually, what I've got is a table
with a varchar2(4000) column holding statements pulled
from various databases (all kinds of statments, not just
selects). What I'm writing is a pl/sql routine to parse
through all these statments and generate a list of the
tables, views and synonyms that are referenced.
I was hoping someone might already have such a script.
> -----Original Message-----
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 25, 2001 2:30 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: looking for a parsing script
>
>
>
> Matt,
>
> What kind of file will the SQL be in?
>
> Do you have a sample?
>
> Jared
>
> On Monday 24 September 2001 07:15, Adams, Matthew (GEA, 088130) wrote:
> > Before I go out an re-invent the wheel (again),
> > I wanted to ask if anyone has a script
> > (preferably pl/sql) for parsing out
> > table references from an SQL statement.
> >
> > Matt
> >
> > ----
> > Matt Adams - GE Appliances - [EMAIL PROTECTED]
> > "Doing linear scans over an associative array is like
> > trying to club someone to death with a loaded Uzi."
> > - Larry Wall (creator of Perl)
>
> ----------------------------------------
> Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
> Content-Transfer-Encoding: 7bit
> Content-Description:
> ----------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
