SQL Programming Tool

SQL Programming Tool is software that provides a platform for database administrator and application developer to perform daily tasks efficiently and accurately.
Database administrator and application developer are facing with a constantly changing environment, which is rarely completely under their control. These changes are typically a result of new development projects or modifications to existing code, which when deployed to production, do not always produce the expected result.
For organizations to better manage development projects and the teams that develop code, they normally provide more than one SQL tool to the database administrator or application developer to ensure database is properly managed and the code is deployed to production in a quality way.
General Features
SQL Editing
    The SQL Editor allows user to edit or execute SQL statements. It normally supports the following features:
        - Cut, copy, paste, undo, redo, find, and replace, bookmarks
        - Block indent, print, save file, uppercase/lowercase
        - Keyword highlighting
        - Auto-completion
        - Access to frequently used files
        - Return query results
        - Allow user to edit query results
        - Commit and rollback transactions
Object Browsing
    It displays all information that is relevant to developer or database administrator. User can use it to get object descriptions, to view object definitions, to create object, to enable and disable triggers and constraints, to recompile invalid objects, to query or edit tables or view data. Some of the tools also provide the features to display dependencies among objects, and lets you recursively expand these dependent objects (e.g. package references view, view references table, super/subtypes, and son on).
Session Browsing
    Database administrator and application developer can use the session browsing tool to view the current activities of each user in the database. They can check the resource usage of individual user, statistics information, objects that being locked and even the current running SQL of each individual session.
User Security Management
    DBA can create, edit, delete, disable or enable any user account in the database using this Security Management tool. DBA can use this tool to assign roles, system privileges, object privileges, and storage quota to users.
Debugging
    It offers the features you could used for Store Procedure debugging such as Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack, and so on. You can debug any program unit without making any modification to it, including triggers and object types.
Performance Monitoring
    It shows the database resources usage summary, service time summary, recent activities, top session, session history or top SQL in easy-to-read graphs. Database administrator can easily monitor the health of various components in the monitoring instance. Application developers can also make use of this tool to diagnose and correct application performance problem.
SQL Programming Tools
The following lists some of the popular SQL Programming Tools in the market:
  dbXpert for Oracle
    dbXpert for Oracle is an easy to use database development and administration tool for Oracle database. It helps developers and database administrators get the job done quickly and efficiently.
    PL/SQL Developer
    PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases.
    TOAD
    TOAD, which was originally for Oracle but has been expanded to include the ability to access other data base management systems. TOAD is now owned by Quest Software.
   Oracle Maestro
    Oracle Maestro is a software application for development and administration of Oracle databases. It comes with database designer, visual query builder, PL/SQL debugger, and OLAP viewer. There are the same products for MySQL, PostgreSQL, DB2, Firebird, SQLite and other popular relational databases.
   ACDB
   ACDB, 100% graphical and real time database management for oracle and mysql, including advanced features such a PL/SQL debugger. ACDB is now owned by Electronic Experience.


More detail please come to me at
http://it.toolbox.com/people/hopitool