Open Source PL/SQL Software Development Software

ScriptRunner was developed to run large sets of SQL scripts. Functionality includes restart at point of failure; audit log; multi-threaded execution; conditional execution; parameter and bind variable substitution; basic error handling; and validation.

Compilo is a documentation project for Compiere ERP/CRM. It's goal is to develop, join and publish documentation about Compiere ERP/CRM from the developer point of view.

Eisti GroupWare, a software development GroupWare application. It includes a UML designer (can import .java files and export xml content), a built in chat system, and a distributed repository system. Writen in java - C, in french for our school project a

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

A project to develop Java-based front-ends to the utPLSQL testing framework. This includes integration with JUnit, Ant and Cruise Control. We are working to release code soon (written September 2004).

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.

Num2Str - convert number to it's Language representation, like: '12345' => 'Twelve thousand three hundred fourty five' Localizable for any language

Problem: How can Oracle PL/SQL applications read, write, move or copy arbitrarily large files to or from arbitrary file system locations? Solution: This utility (OFsX) uses PL/SQL, Oracle AQ & Spring Integration to handle reading, writing, copying, moving & deleting of files from Oracle PL/SQL in a general way. Summary: PL/SQL is an excellent language for developing data-intensive, enterprise applications. However, it can be difficult for PL/SQL applications to interact with a file system (Fs). OFsX makes two-way PL/SQL-to-Fs interaction easy.

Collection of various scripts to automate development with Oracle RDBMS. Includes SQL, PL/SQL and Java. Some are related to Oracle Applications Development.

Javadoc-like tool for PL/SQL

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

spag4j is a code generator written in Java to produce Java code for accessing a stored procedure layer from a database. Currently it supports stored procedures written in an Oracle. It produces either an EJB3 Java layer or simple static access methods.

This site is intended as a location containing a suite of tools to (1) Aid in the design of db APIs to be utilized in a J2EE environment and (2) generate stubs for the db API, Java classes and SQL DDL necessary to support the MVC pattern and the Data Own

Web 2.0 environment for collaborative and extensible design of object interconnection diagrams like UML, networks, circuits and other graph based diagrams. Client: Web-based (AJAX / Dojo Toolkit) Server: JEE Application (Struts Framework)

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.