DA Morgan <damorgan_at_exesolutions.com> wrote in
news:3E5A4C8B.A504814F_at_exesolutions.com:
> 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
>
The book "Perl for Oracle DBA" by Jared Still "contains"
freeware which creates & maintains a "SQL Repository";
which contains both the raw SQL plus EXPLAIN PLANs for
the SQL found withing the V$SQLAREA.
HTH & YMMV
HAND!
Received on Mon Feb 24 2003 - 19:14:36 CST
