Home -> Usenet -> comp.databases.oracle -> Automatic SQL syntax checker

Automatic SQL syntax checker

From: John Smith <linux_email2000_at_yahoo.com>
Date: 28 Aug 2002 10:37:13 -0700
Message-ID: <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 Wed Aug 28 2002 - 19:37:13 CEST












Original text of this message