Open Source PL/SQL Build Tools for Linux

Compiere ERP+CRM is the leading open source ERP solution for Distribution, Retail, Manufacturing and Service industries. Compiere automates accounting, supply chain, inventory and sales orders. Compiere ERP is distributed under GPL V2 by Compiere, Inc.

LOG4PLSQL is a PLSQL framework for logging in all PLSQL code this project was born from the log4J spirit (and use it). You have the possibility to log apart from transaction and use all LOG4J feature.

JDBC Tester is a software that allows to prove JDBC connections and SQL statements. The central idea is to have a software that is used for the design of statements and learning SQL with an graphical user interface simple to use.

Build around JDBC and XML, this tool allows you to maintain visual repesentations of a database's layout, edit table's data, generate code to bind objects to tables, and export data in XML format to easely export data from one database to another.

JSQLEditor is a PL/SQL and PL/pgSQL editor plug-in for Eclipse IDE.

Jipes provides open source Java APIs deeply integrated into the Oracle RDBMS, including an Ant task for building and exporting database objects. A Java Data Cartridge replacing database links is also in process.

Model driven code generation can improve coding standards, speed, quality of development and reduce your costs. From my experience generating code from XML using XSLT is one of the best and fastest solutions. This is just the base of the framework presenting the idea, any code template can be implemented upon request. Some sample generators are present for SQL / PLSQL / C# / AnsiC / Java The main target is to generate DTO/BDO/POJO objects based on the database definitions in multiple languages aligning all technologies used by a development team. If you are willing to contribute drop a message.

Oracle Database Front-End with database navigation, code editor, syntax highlighting and tab completion for database objects.

The OpenOCS project is groupware software which allows groups to work on projects. Client/Server architecture written in Java with a MySQL database and PHP front end.

A tool for the development and customization of an information system for traceability and workflow management of virtually any business process or product.

Define your database structure and relations once using the ZsqlML (Zenark's SQL Markup Language) XML DTD, and then generate mulitple vendor-specific SQL scripts, thereby solving the issue of SQL script variances across multiple platforms.

Incanto is an open source project providing a set of Apache Ant tasks for accessing Oracle tools such as SQL*Plus and Data Pump Import/Export from Ant's XML build files.