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