Home > By category > Business & Productivity Tools >Database Management > Guggi for Oracle



Guggi for Oracle

  • Downloads: 
  • Views: 
  • Rating:

Database Development, Administration, PL/SQL programming and data analysis tool for Oracle 8.0, 8i, 9i and 10g. Are Browse the database for 32 different types of objects such as table, view, synonym, constraints, function, index, trigger, sequence, schema, tablespace, procedure, package, materialized view, database link, type, rollback segment, directory, operator, library, queue, java (data, source, resource, class), context, consumer group, index type, job, profile, queue tables, policy, dimensions, summary, external tables; Tab through the properties of database objects; Several Developer and DBA features backup statistics, Lock Manager, Server Monitor, PL/SQL Profiler, PL/SQL trace, Security Manager, Analyze Manager, Invalid Objects Manager, Input/Output stats, Rollback Segment Manager, Sessions Manager, SQL Stats, Upload and download BLOB, Space manager and Develop PL/SQL code, database objects, tune code.

Features:

 · Browse the database for 31 different types of objects such as table, view, synonym, function, index, trigger, sequence, constraints, clusters, 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.

 · Create database objects such as table, constraint, database link, directory, index, sequence, synonym, advanced queues, library, consumer group, rollback segments etc. through a simple user interface.

 · DBA features (besides performing DDL). :

     1. View latches, locks, waits and instance / SGA/ Session statistics.

     2. View library cache and control files.

     3. View input / output statistics.

     4. View Backup statistics.

     5. View Oracle Parameters.

     6. View free space by tablespace and datafile.

     7. View space taken by each object in the database.

 

 · Database Tools for DBAs and Developers.

     1. Database schema browser.

     2. SQL Editor.

     3. Guggi SQL Editor – SQL editor outside the Guggi for Oracle application.

     4. PL/SQL Editor.

     5. Reports of database objects.

     6. Reverse engineer database objects.

     7. Search objects in the database.

     8. Performance statistical analysis of data such as min, max, standard deviation, variance, standard error, Kurtosis, skewness.

     9. Analyze Manager – analyze tables and indexes.

     10. Invalid Objects Manager – view invalid objects and compile them.

     11. Rollback Segment Manager – manage rollback segments, view active segments and their properties, view current SQL on segments.

     12. Sessions Manager – view current database sessions.

     13. SQL Stats Manager – analyze SQL in the database – hot tables, top bugger gets, top disk reads etc.

     14. User/Schema Role Manager – manager security in the database.

     15. View linked data – view data in tables linked by primary key and foreign key relationships.

     16. View Image – download BLOBs from the database. View image BLOBs.

     17. Upload Binary Data – Save BLOBs in the database (any binary data).

     18. Network Tools – ftp files back and forth from an FTP server. Will add others such as telnet, ping, rexec.

     19. Scientific Calculator – quick on the fly calculations.

     20. SQL*Plus – Open SQL*Plus window.

 

 · Manipulate objects such drop, delete, disable constraints, enable constraints, rollback segment online/offline, commit pending area in consumer groups etc.

 · Tab through the properties of database objects.

 · Filter the table and view data.

 · Add, delete, and update data (in a table) using a simple grid interface.

 · Read the PL/SQL code behind views, materialized views, procedures, packages, functions, triggers, and types.

 · Generate the script for tables, indexes etc.

 · Reverse engineer objects from an exiting database.

 · Set the maximum number of records to be returned by a query or when you scroll the data in a table.

 · A simple and easy to use SQL editor to run queries and generate explain plans.

 · 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.

 · 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.

 · Run individual SQL statements or run a script with multiple statements in the SQL Editor.

 · Debug the PL/SQL code (future enhancement).

 · Open a new schema browser or SQL Editor by right-clicking on the button at the bottom of the screen.

 · Open the window for an already established database connection by clicking on the appropriate button located at the bottom of the application.

 · Reconnect a closed connection by using right-click on the button at the bottom of the screen.

 · Quickly check the system info of your local computer.

 · Easily comment, uncomment text, change case (lower, upper, init cap), change background color, justify (center, left, right) text, wrap text, change font, redo/undo etc.

 · Text formatter to color code key words for easy readability – under development.

 · Execute stored procedures and packages.

 · Object browser window to quickly determine the tables and columns available when writing stored procedures or SQL queries.

 · Refresh the screen to get latest information about database objects.

 · View DBMS output in the SQL Editor window.

 · Change user password.

 · Multiple ways to connect to Oracle - OLEDB and ODBC. Connect as SYSDBA or SYSOPER.

Free download from Shareware Connection - Database Development, Administration, PL/SQL programming and data analysis tool for Oracle 8.0, 8i, 9i and 10g. Are Browse the database for 32 different types of objects such as table, view, synonym, constraints, function, index, trigger, etc.

Publisher: Impact Solutions | License: Shareware | Price: 40.00
Version: 1.6.2 | Size: 9306 KB | Platform: Win2000, Windows Server, WinOther
Released Date: 06-02-2006 | Rating: 0 | Title: Guggi for Oracle

Author Url: http://www.impact-sol.com
Program Info Url: http://www.impact-sol.com/features_guggio.htm
Download Url: http://www.impact-sol.com/download/Guggi.zip
Screenshot Url: http://www.impact-sol.com/screenshots_files/image014.jpg

More downloads from Guggi for Oracle publisher Impact Solutions:

Nouriel Roubini Quotes Picture - There are a total of 11 quotes in this application. I hope you are inspired by them. About: Nouriel Roubini is world famous professor at New York University's - Stern School of Business. He is also the Chairman of Roubini Global Economics....

Money Saving Mom Reader Mobile - Read Money Saving Mom in your mobile phone or tablet

Guggi for Oracle keywords:
Guggi for Oracle related downloads:

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

dbForge Studio for Oracle - dbForge Studio for Oracle is a powerful IDE which helps developers to increase PL/SQL coding speed. It provides Oracle database management tools, allows to synchronize Oracle data and automate schema change management process during development.

dbForge Fusion for Oracle - dbForge Fusion for Oracle is a useful VS plugin for Oracle database development and simplify data management process. It allows developers to explore and maintain existing databases, design compound SQL statements and queries, and manipulate data.

SQL Manager 2011 for Oracle - SQL Manager 2011 for Oracle is professional software solution that can be used for Oracle database development and administration.

SQLTools build - A light weighted and robust tool for Oracle database development SQLTools is a

Shareware Connection periodically updates pricing and software information of 'Guggi for Oracle' from company source 'Impact Solutions' , so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft,  Using 'Guggi for Oracle' crack, password, serial numbers, registration codes, key generators is illegal and prevent future development of Guggi for Oracle.

New Reviews

SnapCrab - Nearly every PC users need to take screenshots from time to time, whether it is for personal or professional needs. While using the basic Windows screenshot capture method is available, it is not adequate for everyone. When you want to capture ...

Autodesk Smoke - Autodesk is the company well known for making some of the most feature rich and versatile tools for 3D modeling, animation and engineering design related work. Its Smoke is a Mac OS specific app that is aimed at professionals involved in ...

Sigma Internet Monitoring - There is no denying the huge importance of internet in human life. Without the web, it has literally become imposable to carry on a lot of personal and professional activities, irrespective of your age, gender and qualification. While the web ...

NovaBench - PC performance benchmarking is something that may not interest average users much but tech savvy lot resort to such apps to find out prowess and capability of their laptops and desktops. While there are quite a few PC benchmarking apps in market, ...

MAGIX Video easy - Editing videos was a complicated task even a few years back and it was restricted to studios and post production areas in general. However, advancements in computer technology and advent of numerous portable video capture devices have made things ...

CyberGhost VPN - There are so many ways available to browse the web nowadays. You can use a plethora of devices and pick from various service providers to get online. However, tech savvy users resort to additional measures to access the internet without being ...

Protector Plus 2014 (32-bit) - Without using suitable security software in PC, you cannot have peace of mind nowadays. Increasing instances of malware attacks and attacking exploits have prompted average PC users to resort to using antivirus and security suites for both home ...

TrustPort Tools - Nowadays, PC users need to deal with several types of third party apps to ensure security and privacy of data. From encrypting files to getting rid of sensitive data, the needs can be numerous. There are many such tools that can be used in this ...

CleanMyDrive - PC experts unanimously agree that using Macs tend to be a smoother and faster experience than running Windows based PCs but the Apple laptops and desktops also need maintenance and performance tweaking, occasionally. Regular web browsing, ...

Norton Zone - With a lot of your data being stored in some cloud service or other, it becomes necessary after a point to zero in on any one service rather than using many at the same time. As it is, major software companies are resorting to cloud based service ...




New Downloads

Alpha Clipboard Recorder

Free Clipboard Record. Alpha
Clipboard is a lightweight,
handy and convenient solution
to expand your Windows
clipboard ...

SSuite Office Premium HD+

This office suite was created
for the professional and
discerning computer user. The
application interfaces have
been ...

HOA Tracking Database
Software

Manage all your Homeowners
Association (HOA) contacts,
communications, work orders
and account billing
information in one ...

Job Designer

Schedule your rooms, employees
and other resources with our
all-in-one solution for
generating quotes, invoices
and ...

Cheewoo Nest 2D

Performing 2D automatic true
shape part nesting using
advanced nesting engine.
Several levels of packing rate
can be ...

Bytescout BarCode Generator

BarCode Generator is able to
generate and export barcode to
image (PNG, JPG, TIFF).
Types: Codabar, Code 39, GS1,
Code ...

ReplaceMagic.Total
Professional

Have you ever been in
situation that you move
documents to new location and
links were broken? This
usually happens ...

Barcode Generator for
Microsoft Access

Create barcodes in Microsoft
Access without installing
additional fonts or other
components with the
IDAutomation Native ...

3DINTERSECTION for AutoCAD

An add-on for AUTOCAD or
BricsCAD which determines the
intersection curves between 2
sets consisting of 3DFACE,
3DSOLID ...

CRM-Express Ultimate

CRM Software - CRM-Express can
manage your marketing,
customers, sales and orders.
Features include SMS
abilities, Email ...

Asoftech Automation

Asoftech Automation records
all operation of mouse and
keystrokes and saves them as
macros. It can play back the
recorded ...

Nevron Chart for SSRS

Nevron Chart for SSRS
(market\'s leader for its
visual style, effects,layout
features and data integration)
is a ...