Re: Automatic SQL syntax checker

From: wangz <php_at_yeah.net>
Date: 28 Aug 2002 20:34:53 -0700
Message-ID: <6f77ff2a.0208281934.2984a93_at_posting.google.com>


We are developing a tool to check Sql Syntax. and just want to know is there anyone who really need it. The original goal for us to develop this tool is used for pretty sql print.
anyone who interest in tool like this please give us your comments and requirements to help us build a more useful tool.

Gudu Software
http://www.wangz.net

linux_email2000_at_yahoo.com (John Smith) wrote in message news:<248a20a2.0208280937.66979ddc_at_posting.google.com>...
> Hello All,
> I was wondering if you all knew of a PL/SQL procedure (or a Java
> API) supplied by Oracle/Someobe Else/Open Source that takes in an SQL
> statement and automatically checks to see if it is valid.
>
> Requirements are like so:
>
> #1. Test for Syntax validity (i.e. select seq_nextseq frm dual, this
> is incorrect)
>
> #2. Test to make sure that a table or column actually exists that is
> specified in an SQL statement.
>
> If anything out there does the first, second or both requirements
> please let me know!
>
> Regards,
>
> John
Received on Thu Aug 29 2002 - 05:34:53 CEST

Original text of this message