• 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic