Re: sql parser for oracle 9i

[Quoted] [Quoted] You could write it using awk or Perl (or some other scripting lang) [Quoted] 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,
>>>
[Quoted] >>>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 ?
>>>
[Quoted] >>>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