Database Development, Administration, PL/SQL programming and data analysis tool for Oracle

8.0, 8i, 9i and 10g.

Guggi-Oracle has following features currently supported for programming, development and

administration of Oracle databases:

1. Browse the database for 28 different types of objects such as table, view, synonym,

function, index, trigger, sequence, schema, tablespace, procedure, package, java class,

materialized view, database link, type, rollback segment, directory, operator, library,

queue, java data, java source, java resource, context, consumer group, index type and job

2. Tab through the properties of database objects 3. Create database objects such as constraint, database link, directory, index, sequence,

synonym and table through a simple user interface 4. Filter the table and view data 5. Add, delete, and update data (to a table) using a simple grid interface 6. Read the PL/SQL code behind views, procedures, packages, functions, triggers, and types 7. Generate the script for tables, indexes etc 8. Reverse engineer objects from an exiting database 9. Set the maximum number of records to be returned by a query or when you scroll the data

in a table 10. Check the free space in the database for individual datafile and for tablespaces 11. Go through the session history. Check the current SQL and percent complete 12. Check the instance summary, latches, locks and waits 13. Review the Oracle database parameters 14. Check the current registry Oracle related registry values on your local computer 15. Generate reports 16. Determine statistical parameters such as minimum, maximum, average, standard deviation,

variance, standard error, kurtosis, skewness of data stored in tables 17. Quick link to SQL*Plus 18. Use a scientific calculator to do quick, on-the-fly calculations 19. A simple and easy to use SQL editor to run queries and generate explain plans 20. A simple and easy to use PL/SQL editor to develop code