Re: sql parser for oracle 9i

Ron Reidy wrote:

> You could write it using awk or Perl (or some other scripting lang)
> which would look for statements begining with one of the SQL*Plus verbs
> and ending with either a ';' or '/'.
>
> This would not validate the SQL as is done during the parse phase in the
> database, but it would give you the statements.
>
> --
> Ron Reidy
> Oracle DBA
>
> christian kasper wrote:
> > DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E565679.3511E8A3_at_exesolutions.com>...
> >
> >>christian kasper wrote:
> >>
> >>
> >>>hello,
> >>>
> >>>i need a sql parser for oracle 9i.
> >>>
> >>>do you now a company or a open software project or something, where i can get
> >>>the parser ?
> >>>
> >>>thank you.
> >>>
> >>>christian kasper
> >>
> >>What is wrong with the one in the Oracle database?
> >>
> >>Daniel Morgan
> >
> >
> >
> > Thank you fro your help.
> >
> > You are right, the kontext of my parsing problem is important.
> >
> > I have a application with thousands of sql statements in pl/sql
> > scripts, in triggers, in pro*c programs, in shell scripts …..
> >
> > My work in the project is to develop a scanner for
> > insert/update/select/delete statements to describe the r/w access per
> > procedure/trigger/function/script on tables/views. The output of the
> > scanner is a html file that describes the relationship between
> > procedure/trigger/function/script and r/w access on tables/views for
> > documentation purposes.
> >
> > My question is, do you know a parser, who give me the names of
> > tables/views in selects/insert/update/delete statements. The parser
> > must know the syntax from oracle 9i.
> >
> > Thank you
> >
> > Christian Kasper

Given dynamic SQL I think any 'general' attempt is doomed.

Daniel Morgan Received on Mon Feb 24 2003 - 17:47:07 CET