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 write and compile your PL/SQL code. Easily check the error messages and fix them.
21. Find database objects across all schemas
22. Export data from an existing table or a query in csv, tab delimited or user-defined delimited format. Export the data to Excel. Export the table data as insert statements.
23. Run individual SQL statements or run a script with multiple statements in the SQL Editor
24. Debug the PL/SQL code (future enhancement)
25. Open a new schema browser or SQL Editor by right-clicking on the button at the bottom of the screen
26. Open the window for an already established database connection by clicking on the appropriate button located at the bottom of the application.
27. Quickly check the system info of your local computer
28. Easily comment, uncomment text, change case (lower, upper, init cap), change background color, justify (center, left, right) text, wrap text, change font etc.
29. Text formatter to color code key words for easy readability
30. Execute stored procedures
31. Object browser window to quickly determine the tables available when writing stored procedures or SQL queries
32. Refresh the screen to get latest information about database objects
33. View DBMS output in the SQL Editor window
34. Change user password
35. View all invalid objects
36. View free space information for various database objects
37. View data linked by primary key and foreign key relationships
38. Multiple ways to connect to Oracle - OLEDB and ODBC. Connect as SYSDBA or SYSOPER