Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need some SQL Validator

 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to write some big insert queries to perofrm my operation , somehow i am making some mistake in writing

SQL queries like missing comma and lot of time is wasted in checking the syntax of the query .

Please let me know Is there any tool that checks the syntax .
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Most (if not all) database clients provide SQL validation.
 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you paul .

Means i am getting SQLExceptions like missing comma .

Is SQL Developer have this facility ??
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you . I will check with SQLDeveloper .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic