Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL syntax building tool
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
![]() |
![]() |