CHANGE LOG: Guggi for Oracle

New Changes in Version 1.5.6 - Released Nov 30, 2005

1. Added a new tool called Stored Procedure Helper. Execute stored procedures 
and view the output. Support provided for ref cursors (upto 10 ref cursors), varchar2,
char, number and date. User can now view the data in the ref cursors returned by the 
stored procedure (package, procedure, function). Input and output values are visible in the tool.

2. Enhanced the Quick ERD tool. Earlier the tool displayed a maximum of 9 related tables.
The tool now has no such limitations. User can now page through the related tables, and 
all table relationships are now displayed in sets of 9.

3. Enhanced create database link to create shared, current user and connected user links.

4. Added icons to database links pane to indicate public or private links.

5. Added icons to trigger pane to indicate enabled (yellow bullets) or 
disabled (blue bullets) status.

6. Added icons to rollback segment pane to indicate online (yellow bullets) or 
offline (blue bullets) rollback segments.

7. Added icons to schema pane in schema browser to indicate open or locked accounts. This is available only if DBA% views option is selected in Application Options.

8. Added extra functionality to create dblink screen.

New Changes in Version 1.5.3 - Released Nov 7, 2005

1. Redesigned reverse engineer tool. Now the user can reverse engineer all the objects
(Oracle ver. 9.2 upwards). The user can also reverse engineer a selected list of objects
of a given object type. For example, the user can select to reverse engineer 5 of 10 tables in a given schema. 
There is an option to select objects from ALL_OBJECTS or DBA_OBJECTS view.

2. Added run till exception, abort execution to PL/SQL debugger. Improved error messaging 
in debugger.

3. Added support for all object types in SQL editor. Support for object tables is planned for next release.

4. Enhanced Sessions Manager to show I/O stats, current waits, wait events, session stats etc.

5. Added sort on click to Storage Manager grids.

6. Moved some tools such as Rollback Segment manager, Sessions Manager etc. under Database and DBA tab since these tools are truly DBA tools.

7. Added right-click menu to sql editor, plsql editor, schema browser object panes

8. User can now execute SQL statements ending in a semi-colon (";"). The user no longer gets the "Invalid Character" error.

9. Added the functionality to view data from sql query in a textpad in SQL window.

10. Added the application option to run DML either in background thread or in the main SQL Editor window.

New/ Changes in Version 1.5.0 - Released Oct 5, 2005

1. Added PL/SQL Debugger. This was a long-pending tool to be added to Guggi Oracle. This provides a significant enhancement to PL/SQL abilities along with code compilation, profiler and trace.

Debugger Supports: Step into, Step over, Step out, add breakpoint, delete breakpoint, get value, set value, variable watch list, stack trace.

Run till excecption will be added in the next release

How to use the debugger:

a. Launch the debugger from Tools menu option
b. Type in a PL/SQL anonymous block. Anonymous block is needed for all PL/SQL code - package, procedure, function
c. Click on first button - start debugger
d. Click on continue or step into or step over or step out
e. Enter the watch variables in the lower left grid and values will be displayed in the grid.
f. Once the debugging is done, the first and last button will become enabled and other buttons will be disabled.


2. Added latch Monitor - a DBA tool. View latch holders and latch waiters.
3. Improved the DDL for tables - added indexes and constraint scripts
4. Consolidated free space tablespace and object space into Storage Manager. View space taken by objects in a given schema. View space taken by objects in a given tablespace.
5. Added several editing features to the SQL and PL/SQL editor
6. Improved the sizing of the controls on severl windows as waits-latch-lock, upload blob, view image, SQL stats etc.
7. Added User Guide.
8. Much more ...

New/ Changes in Version 1.4.7 - Aug 25, 2005

1.  Added Quick ERD tool.  The tool can be accessed from the Schema Browser by clicking on the sixth icon.  The tool shows the relationship the selected table has with other tables in the same schema.
Relationship with tables in other schemas is not shown.  If the table has a foreign key (FK) which is also a part of the primary key (PK) then the Quick ERD tool will show the column as FK but not both.
2.  Enhanced Syntax highlighting.
3.  Updated SQL Editor -
       a. records can be retrieved in increments of 25.
       b. all records can be retrieved from the database.
       c. record retrieval can be cancelled.
       d. copy explain plan to the clipboard.
       e. maintain a buffer of SQL statements in the SQL Editor.  Besides storing SQL statements in the SQL history, the statements are saved in the SQL buffer. These statements can be retrieved from the buffer. Also, enhanced the Guggi SQL*Editor with above features.  Improved the Explain Plan.
4.  Enhanced PL/SQL editor to improve syntax highlighting while editing.
5.  Passwords are saved in the registry.  You can logon to the database by double-clicking on the right side user/database list in Login Window.
6.  Added histogram to table details.
7.  Added External table and Queue Table tabs.
8.  Added job type details.
9.  View object details by pressing ctrl-Q in PL/SQL editor window.
10. Fixed some bugs.

New/ Changes in Version 1.4.5 - July 17, 2005

1.  Added PL/SQL Trace.  This is a good addition to trace PL/SQL calls and can be used with PL/SQL profiler to fine tune the PL/SQL code.
2.  Added the feature to execute DML (insert, delete and update) in a background thread.
3.  View the Schema Browser with and without the left pane (one that displays all objects of a given type).
4.  Added the ability to change the control size with SQL Editor, User Schema Manager, Sessions manager, PL/SQL Profiler, Guggi SQL Editor and other forms. This is in progress.
5.  Press ctrl-Q in SQL Window and a window pops up that displays the details of a given object.
6.  Improved the Explain Plan of the Sessions Manager window.
7.  No limit on size of PL/SQL code to be compiled.
8.  Main menu is now available in multiple languages - English, German, French and Spanish.  The menu language can be adjusted using Application Options.
9.  Added the option to select from ALL% dictionary views or DBA% dictionary views.
10.  Added option to set the left panel size that displays the list of objects.
11.  Other minor enhancements and bug fixes.

New/ Changes in Version 1.4.4 - June 26, 2005

1.  Added Server Monitor.
2.  Enhanced user managed application options.
3.  Add several graphical presentation of database features.
4.  Sorting of data in grids by clicking on the grid column header.

New/ Changes in Version 1.4.0 - June 5, 2005

1. Added PL/SQL Profiler.
2. View Temporary objects.
3. View the code of the synonym.
4. Improved the intellisense.
5. Added graphics for better visualization of data.
6. Many more new features which I forgot to document.

New/ Changes in Version 1.3.9 - Apr 20, 2005

1.  Change the connection without opening a new form. You can change the connection while on a screen by clicking on the last button on the main toolbar.  A drop down box will open up and you can select the connection.  The content of the screen will change according to the new connection.
2.  Added more intellisense to the SQL and Procedure editors.
3.  Improved the Explain plan to display the records as a tree.
4.  Addded the Lock manager to view various types of locks.
5.  Edit text columns in the schema browser - Table data display.  It is difficult to edit text columns (varchar2, char, clob) in the datagrid.  Now select the cell you want edit (must contain text data), click on the notepad icon and modify and save data.  Click on the "check mark" to accept and commit changes.
6.  Fixed the display of some the screens (such as procedure, package etc.).
7.  Made it easier to view only text or only data in the SQL editor.
8.  Added line numbers to the SQL editor and Procedure editor text areas.
9.  Fixed some bugs.

New/ Changes in Version 1.3.8 - March 10, 2005

1.  Fixed the sort order on SQL History table.
2.  Added Single view record of data in a table or a query.  Data can be updated in the single view record.
3.  Added parameter identification - when you run a query with input parameters, the application will prompt you to enter the parameter value.  The default parameter character is &.
4.  Modified the statement id of plan table to varchar2(32) from varchar2(200).
5.  View CLOB data in data grid using Oracle OleDb driver.
6.  Added intellisense in SQL-Editor to detect a table or view and display it's columns which can then be selected to print on the main SQL Editor window.  The intellisense window opens up when the "." character is typed in the SQL-Editor window.
7.  Added icons to table and index browser (partitioned vs non-partitioned), view, procedure, package (valid vs invalid), constraints (unique, primary key, foreign key), tablespace (undo, permanent, temporary).
8.  Get immediate view of table structure by pressing Ctrl-Q when the cursor is on the table name.  Will extend this to view and other object types in the future release.

New/ Changes in Version 1.3.5 - Feb 27, 2005

1. Modified the application so that the screen controls can adapt to screen resolution. Earlier the application dimensions were fixed at 1024 X 768 but now with change in screen size the application size changes.
2. Added Guggi SQL Editor as a built in as well as an independent SQL editor.
3. Added Create Consumer Group Functionality.
4. Added Create Cluster functionality.
5. Added Network Utilities - FTP
6. Added details for CONTEXT, CONSUMER GROUP, JAVA class, java data, java resource, java source
7. Added a new object - CLUSTER
8. Added a new object - DIMENSION
9. Added a new object - SUMMARY
10. Added a new object - POLICY
11. Added Constraint Details.
12. Grouped Java class, data, resource and source under one tab called JAVA.
13. Minimized Syntax highlighting. Syntax highlighting is being revamped.
14. Added index partition details.
15. Login screen boxes now show the last login username, password and database connection.

New/ Changes in Version 1.3 - Feb 7, 2005

1. Added View Image manager - view images stored in the database as BLOB. You can download non-image binary data also.
2. Added Upload BLOB manager - upload binary files into BLOB columns of the database.
3. Added Create Queue screen - create advanced queues.
4. Added feature to retrieve past SQL statements.
5. Added filter to the Synonym tab.
6. Added the option to kill a session from Sessions Manager window.
7. Added Options feature to set Application level options such as max records, first window after login, font in the sql window.
8. Added more functionality to trigger toolbar such as enable, disable trigger, syntax highlighting.
9. Fixed loading of Triggers and Types into Procedure Editor.
10. Added Count of Records to tables data tab.
11. Fixed Save button bug in SQL / PLSQL window.
12. Added column to table column list to indicate whether the field is nullable.
13. Fixed loading of package code in PL/SQL editor. Code is loaded after displaying it first.
14. Fixed the SQL editor so that you can put comments in the SQL code.
even when connected using Oracle's OLEdb.
15. Improved syntax highlighting.

New/ Changes in Version 1.2 - Jan 27, 2005

1. Backup Manager.
2. Cache, Control Files.
3. File and System I/O Stats.
4. Modified Latches, Locks Waits.
5. More functionality for Advanced Queues such as stop and start dequeue and enqueue.
6. Added Sequence Report.
7. Improved the Procedure Editor and SQL editor : view columns for tables while writing the code.
8. Compile large PL/SQL blocks (more than 32K characters in size).
9. Compile PL/SQL blocks using both Microsoft OLEDB and Oracle OLEDB.
10. Compile all objects - packages, procedures, views.

New/ Changes in Version 1.1 - Jan 16, 2005

1. Analyze Manager - analyze database tables and indexes.
2. Rollback Segment Manager - analyze what transaction each rollback segment is supporting.
3. SQL Stats Manager - SGA trace and see hot statement and hot tables.
4. User/Schema Role Manager - Manage user security, grant and revoke privileges.
5. Added the functionality to create a Rollback Segment.
6. Functionality to close a single connection or all connection with the option to commit or rollback.
7. Functionality to reopen a closed connection by right-clicking on the applicable button at the bottom of the application.
8. Added a new report for Tables and constraints.
9.Enhanced GUI.
10. Improved Invalid Objects Manager to compile invalid objects. Objects can be recompiled from the Schema Browser also.
11. Added filter to View Linked Data functionality. Now you can filter data from the starting parent table10. Fixed the filter on Table and View data so that the filter condition is not lost once the filter is closed.
12. Fixed the Explain plan statement

Version 1.0.0 - Jan 1, 2005 

Oracle is a registered trademark of Oracle Corporation. DB2 is a registered trademark of IBM Corporation.