A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Java 8 in Action
this week in the
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 - Experts at Building Test Data
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
How to use Bind Variable with FROM and UPDATE clauses in PreparedStatement???
Specifying Table Name Dynamically in Insert Statement....
avoid sql injection
Java Lib to Validate SQL Query for Syntex
does OracleDriver really precompile a PreparedStatement?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014