aspose file tools*
The moose likes JDBC and the fly likes Need some SQL Validator Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Need some SQL Validator " Watch "Need some SQL Validator " New topic
Author

Need some SQL Validator

Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

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 .

Save India From Corruption - Anna Hazare.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Most (if not all) database clients provide SQL validation.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Thank you paul .

Means i am getting SQLExceptions like missing comma .

Is SQL Developer have this facility ??
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Yes.
Ravi Kiran Va
Ranch Hand

Joined: Apr 18, 2009
Posts: 2234

Thank you . I will check with SQLDeveloper .
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Need some SQL Validator