Re: Automatic SQL syntax checker
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.
Gudu Software
linux_email2000_at_yahoo.com (John Smith) wrote in message news:<248a20a2.0208280937.66979ddc_at_posting.google.com>...
anyone who interest in tool like this please give
us your comments and requirements to help us build
a more useful tool.
http://www.wangz.net
> 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