Re: sql parser for oracle 9i

Hi Christian.

How soon do you need it? At ChangeGroup we have just released the first beta version of ChangeGroup Open System Documentary (CGOSD), a system documentation generator that in some senses could be regarded as Javadoc for Oracle. For the next beta release we are in fact considering the functionality you request.

For more information about CGOSD, please refer to http://www.changegroup.biz/en/cgosd.psp.

HTH. Finn

--
---------------------------------------------------------------------------
 Finn Ellebaek Nielsen                           ChangeGroup ApS
 Product Manager, Principal Consultant, Partner  Kronprinsessegade 54, 4.
 E-mail: finn.ellebaek.nielsen_at_changegroup.dk    DK-1306  Koebenhavn K
 Mobile: +45 20 32 49 25                         Denmark
 Phone:  +45 33 32 77 78                         http://www.changegroup.dk
---------------------------------------------------------------------------
                      "Where do you want to GPF today?"
"christian kasper" <christian_at_kasper.ws> wrote in message
news:329aa663.0302240554.395c6bdb_at_posting.google.com...


> Mike <mike_at_nospam.demon.co.uk> wrote in message

news:<HxTQltBw0jV+Ewbd_at_ntlworld.com>...


> > In message <329aa663.0302210615.1a65aa42_at_posting.google.com>, christian

> > kasper <christian_at_kasper.ws> writes

> > >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

> >

> > In what context ?

> >

> > If you need to validate sql statements then the built in package

> > dbms_sql will suffice.

> >

> > Cheers

>
>


> 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