|
|
1. |
ClearSQL by Nordic Tree Software
-
A tool for formatting PL/SQL source code and reviewing it for deficiencies in the areas of readability, program structure, maintainability and correctness. It catches over 40 common coding mistakes and gives suggestion as to coding best practice. ClearSQL can be used to do a quick syntax check on code without sending code to the server. [Shareware]
|
|
|
2. |
DBPartner for Oracle
-
Tune and debug SQL, PL/SQL. By Compuware. [Commercial]
|
|
|
3. |
Embarcadero Technologies
-
Development environment for SQL and PL/SQL, with optional debugger and profiler. Includes tools for Transact-SQL, Java, HTML. [Commercial]
|
|
|
4. |
JDBExplorer
-
Stored procedure development tool for both PL/SQL and Java stored procedures. By Manton Computer Associates. [Free evaluation]
|
|
|
5. |
Log 4 pl/sql
-
Generic tool for logging, benchmarking, and monitoring custom PL/SQL code, inspired by "log4j" [Open source, GPL]
|
|
|
6. |
Material Dreams
-
PL/SQL trace tool, table exporter, session manager, shared pool profiler, and other tools. [Commercial]
|
|
|
7. |
ocitrace
-
A dynamic library (.dll/.so) loaded into memory at user side it tracks all OCI calls issued by programs run at user side. [Open source, MIT License]
|
|
|
8. |
OraTools
-
Execute, test, and debug SQL and PL/SQL statements. By Core Lab. [Commercial]
|
|
|
9. |
PL/SQL Developer
-
Single product that includes editor, and debugger. By Allround Automations. [Commercial]
|
|
|
10. |
pldoc
-
Open source utility, analogous to javadoc, that generates PL/SQL code documentation in HTML. [Open source, LGPL]
|
|
|
11. |
Quest Software
-
SQL Navigator, TOAD, Knowledge Expert, Formatter Plus [Mostly commercial; some freeware versions]
|
|
|
12. |
Software tool reviews for Oracle developers and DBAs
-
Semi-independent third-party review of various PL/SQL development products.
|
|
|
13. |
SQL*Object Builder
-
PL/SQL editor, debugger, SQL execution plan analyzer. By IDB Consulting. [Commercial]
|
|
|
14. |
SQL-Programmer
-
Cross-platform database aqpplication development environment, formerly sold by Sylvain Faust Software. By BMC Software. [Commercial and free versions]
|
|
|
15. |
SQLTools
-
A light weight and robust tool for Oracle database development. It includes a text editor, SQL console and utilities. [Freeware]
|
|
|
16. |
SwisSQL
-
Oracle to Java edition helps convert Oracle PL/SQL procedures to Java. By Vembu Technologies. [Commercial]
|
|
|
17. |
TimeLayer
-
Generates DDL and PL/SQL source for handling time varying data (temporal data), audit trail and/or change approval in a new or existing information system.
|
|
|
18. |
Unicenter SQL-Station
-
Edit, test, tune, and debug SQL and stored code (works with Oracle, Microsoft and Sybase). By Computer Associates. [Commercial]
|
|
|
19. |
Benthic Software
-
PLEdit: a PL/SQL editor, one of several Oracle tools. [Commercial]
|
|
|
20. |
dbSaint
-
A productivity tool for database developers DBAs and analysts. It has powerful SQL editor, schema browser and PL/SQL editor. It has more than 500 mini-tools to provide intuitive GUI to create and manage database objects. [Free for personal use]
|
|
|
21. |
DreamCoder for Oracle
-
PL/SQL development environment that includes a debugger. Several editions available; high-end edition includes a code generator. By Mentat Technologies. [Commercial]
|
|
|
22. |
Isidian SQL Insight
-
A tool that enables users of an Oracle database to easily create and optimize their SQL code for application development, administration, or ad-hoc reporting. [Commercial]
|
|
|
23. |
KeepTool
-
Oracle-related products include a developer's environment known as Hora, and a PL/SQL debugger. [Commercial]
|
|
|
24. |
Oracle Developer Suite
-
Includes various PL/SQL code generators in "Designer" component, also PL/SQL Procedure Builder [Commercial]
|
|
|
25. |
Pl/Sql tidy
-
Allows the user to tidy and format PL-SQL code in a batch file or DOS prompt. [Freeware]
|
|
|
26. |
Pl/Sql+Pdf=Pl/Pdf
-
Generate dynamic PDF documents from data stored in Oracle databases using the PL/PDF program package. [Commercial]
|
|
|
27. |
Qnxo: Quality in, Excellence Out
-
An active mentoring software designed by Steven Feuerstein to help PL/SQL developers and Oracle DBAs develop high-quality applications based on best practices. [Commercial]
|
|
|
28. |
Semantica Groep B.V.
-
Creator of various PL/SQL libraries and tools. PL/Run is a PL/SQL API solution that manages all background processes on one or more servers. PL/File offers file-, directory- and zip file functionality from within Oracle. PL/Crypt offers digest, encryption-, secure random and key generation-, and compression functionality from within Oracle. DocsDB allows to integrate document management and archiving solutions directly into applications.
|
|
|
29. |
SQLGrid
-
An interactive query tool for Oracle developers. This is a SQL Worksheet replacement with a host of additional commands. SQLGrid provides a way to execute arbitrary SQL or PL/SQL code and also investigate how it is execute and its resource consumption. By Information Construction Company.
|
