Re: Automatic SQL syntax checker

We have just announcement a SQL validation tool named EasySQL Checker for Oracle,you can try it. download it from http://www.wangz.net

Originally posted by John Smith
> 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

--
Posted via http://dbforums.com