A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Validate SQL Queries
Joined: Aug 13, 2001
Feb 18, 2003 23:29:00
Is there any way I can validate the syntax of an SQL query in
without actually executing it in the database ?
Joined: Feb 03, 2003
Feb 19, 2003 10:04:00
CHeck and see if your Database server has a SQL console you can use, and try your SQL there.
Joined: Jul 11, 2001
Feb 19, 2003 10:08:00
If you are needing the syntax to be checked in your program, look into Regular Rxpressions for checking the syntax. It's how compilers work.
GenRocket - A Test Data Generation Platform
Joined: Oct 11, 2000
Feb 19, 2003 22:44:00
Asked (and answered -- by me) in this forum:
[Assumes you are using an Oracle database!]
I agree. Here's the link:
subject: Validate SQL Queries
does OracleDriver really precompile a PreparedStatement?
Specifying Table Name Dynamically in Insert Statement....
Java Lib to Validate SQL Query for Syntex
How to use Bind Variable with FROM and UPDATE clauses in PreparedStatement???
avoid sql injection
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013