Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Verifying Queries

 
Chinmay Bajikar
Ranch Hand
Posts: 159
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
Is there any Query parser which will look at the Query and tell me that the Query is right.
I m writing a Gui appln to allow user to write a qry thru a gui.After the qry is formed i need to chk if the qry is properly generated.
Thanks in adv,
Chinmay..
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
well someone suggested doing an 'explain plan' for the query.
personally i dont like the idea of syntax checking queries. really the only way you are going to check if the query is ok is by running it.
my 2c
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic