SQL formatter Web Service
We are pleased to let you know that SQL formatter web service is available now. This is another chooice for you to use our SQL formatter, Besides using free online version at , you can use this SQL formatter…
General SQL Parser Java v0.3 release
In this release, General SQL Parser can fetch all tables and columns in select/delete/insert/update and create table statement. Use this SQL Parser Java version, It’s very easy to find out the tables have Create, Read, Update, Delete and Insert operations…
Java nosuchmethoderror when run demo application of General SQL Parser
If you compile demo applications shipped with General SQL Parser Java version library “by hand” (typing javac and java in a command window). Make sure set your classpath library correctly before compile and run demo applications, otherwise, there will be…
General SQL Parser Java v0.2 release
In this release, General SQL Parser can fetch all tables and columns in select statement. It supports SQL dialect of Oracle and SQL Server database . This feature will be very useful if you need to analyze tons of SQL…
New release: SQL Pretty Printer 3.1.0
Hello everyone! It’s been three months since our last release(v3.0.7), and it feels much longer for some reason. We’ve been really busy. How have you been? We missed you! 🙂 We have some nice updates for you today. Portable version…
General SQL Parser Java Version 0.1
I’m very excited to let you know that General SQL Parser Java Version 0.1 was finally released in 01-22-2010. This is the first release of general sql parser java version. This SQL parser had a solid infrastructure now, with the…
Correlation names and Column name qualifiers in correlated references
A correlation name can be defined in the from clause of a query and in the first clause of an update or delete statement. for example, the clause FROM X.MYTABLE Z establishes Z as a correlation name for X.MYTABLE. With…
How to find out datbase version using SQL query
DB2 SELECT versionnumber, version_timestamp, Substr(authid, 1, 20) FROM sysibm.sysversions MySQL SELECT Version(); SQL SERVER SELECT @@VERSION Oracle SELECT * FROM v$version;
SQL Language elements (characters)
characters, the basic symbols of keywords and operators in SQL language are the single-byte characters that are part of all IBM character sets. charaters of language are classified as letters, digits or special characters. A letter is any of the…