Guggi-Oracle 1.0.0
Database Development, Administration, PL/SQL programming and data analysis tool for Oracle 8.
|
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
tags check the sql editor database objects sql code export the and easy simple and the sql stored procedures text change the screen the bottom local computer
Download Guggi-Oracle 1.0.0
Purchase: Buy Guggi-Oracle 1.0.0
Similar software
Guggi-Oracle 1.0.0
Impact Solutions
Database Development, Administration, PL/SQL programming and data analysis tool for Oracle 8.
Database Gate 1.9
Stefano Grassi
Database Gate is SQL editor able to connect to every kind of database using ODBC.
Database Voyager 1.5
Elkom Expert
Database Voyager is a powerful utility with an intuitive graphical user interface to Oracle databases.
EasyStruct Enterprise 4.5 SE
Vishwak Solutions, Inc
Document your database structure and generate customized reports as xml, html or Microsoft Word documents.
Sonswish 1.33
RustemSoft
Sonswish is an Oracle database browser, available as a desktop application.
DTM Schema Inspector 2.00.07
DTM soft
DTM Schema Inspector is a database schema browsing and management tool that let you work with database schemas more effectively.
DB Solo 2.1
DB Solo Team
DB Solo is a powerful yet affordable cross-platform database development and management tool for both developers and DBAs.
SqlSpec 6.5
ElsaSoft
SqlSpec is an application for generating SQL Database specs.
dbDeveloper 2.18
Prominentus
dbDeveloper is visual development tool for multiple databases exploration, design, creation and modification in an easy and powerful way.
Database Information Manager 2.5
Scalabium Software
Database Information Manager gives you a clone of SQLExplorer.