Hello Guggiusers

Version 1.5.9 of Guggi for Oracle has been released.
The product is set to expire on Feb 28, 2006.

Following features have been added to version 1.5.9


1. Added SQL Access Advisor - Quick Tune, Tune SQL from Cache, Tune
SQL from user workload, Tune SQL for a Schema, Tune MV. These
features are relevant for Oracle 10g only. Needs package called
DBMS_ADVISOR which is installed when Oracle database is created.

2. Added support for query execution using bind variables. Support
is provided for Date, String and Number bind variables.
Also, the user can have both replacement and bind variables in the
same query.

Note: If the parser incorrectly picks a string as a bind variable
(e.g., in date format displaying hh24:mi:ss), the datatype should be
selected as "Ignore-Not bind variable".

3. Made the forms moveable. After debating a lot, we have decided
to make the forms running within the application moveable.

4. Added right-click menu to some more object types (procedures,
packages, types etc.) in the schema browser

5. Enhanced functionality of SQL editor and PL/SQL editor. By
pressing Ctrl-[, name of the objects that match the selection will be
displayed in a pop up box. For example, type

select * from sa

Now press Ctrl [

A list of objects including table SALGRADE will be displayed. Now
the user can select, salgrade and it will complete the SQL as follows

select * from salgrade

6. Some bug fixes - better error messaging in PL/SQL editor,
handling of nulls in Stored Procedure Helper, etc.

Although this release will expire in 60 days instead of 30 days,
users may want to download again around end of January, 2006
to get a newer release. We plan to have one new release every 30
days.

WISH YOU ALL HAPPY HOLIDAYS

Best Regards,

Shakti Goel
http://www.impact-sol.com
Developers of Guggi for Oracle - Tool for DBAs and Developers