Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: looking for a parsing script
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:jkstill_at_cybcon.com]
> 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 - matt.adams_at_appl.ge.com
> > "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: jkstill_at_cybcon.com
![]() |
![]() |