Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL syntax building tool

SQL syntax building tool

From: David Morse <davem405_at_attbi.com>
Date: Sat, 05 Oct 2002 00:03:35 GMT
Message-ID: <r%pn9.41423$xI5.8693@sccrnsc02>


 Dear database profesional,
Sqlizer is a visual tool for building even the most complex SQL queries. Queries are built by picking from lists of tables and their elements, SQL options, and clicking buttons to proceed. It is designed to help database users create standard SQL syntax based on SQL89 with ODBC extensions
(functions, outer join, date/time values) and some optional SQL92 features
(CAST, IS UNKNOWN). Sqlizer supports grouped, summary and union queries. It
supports joins, subqueries, expressions, functions and type conversions. Data entry is required only for literal values, optional column headings and special options. The resulting SQL statements can be named and saved for reuse and modification later. While SQLizer is an excellent SQL learning tool, some understanding of SQL terms and commands is required to take full advantage. A complete SQL Tutorial section is provided in the documentation.

Sqlizer is written in 100% Java and should work with any database that supports JDBC and works great with Oracle. SQLizer can also be embedded in applications to provide its end-users with an easy tool for creating new SQL queries and reports.

We are currently looking for beta testers so if you are interested feel free to contact me.

Dave Morse
dave_at_firstsql.com Received on Fri Oct 04 2002 - 19:03:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US