SQL programming tool
Overview
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
The following lists some of the major features of SQL Programming Tools.
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 dependant 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
- AQT is a fast and easy-to-use cross-database query tool. With a powerful query environment and a wide range of DBA and developer tools, it is the ideal database product irrespective of whether you are a data analyst, DBA or developer.
- DBDiff for Oracle is a database utility that performs a comparison between two Oracle databases and can also automatically create scripts to upgrade from one database to the other.
- DB Tools for Oracle is an integrated set of "must-have" tools for monitoring, tuning, diagnosing, coding, creating, editing, benchmarking, and reporting for Oracle databases.
- 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 is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases.
- Embarcadero Rapid SQL, an integrated cross-platform database development environment, raises productivity for both novice and expert programmers.
- 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.