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.

C-squares is an easily implemented method for storage, querying and display of spatial data locations, based on a hierarchical, grid-based representation of the Earth' surface. Source code for encoding, decoding, mapping, etc. is provided via this site. Additional support is available by contacting the system developer, Tony.Rees@marinespecies.org; see also the c-squares home page at http://www.cmar.csiro.au/csquares/ .

.NET library (written in C#) for developers writing data access code that is less cumbersome than straight ADO.NET and is almost entirely database platform independent for most database platforms.

HIPAATalk - Contains stored procedures and sample DTS packages for parsing and converting X12 to flat tables and creating HIPAA-compliant X12 files. Currently reads 820, 834, 835, 837P/I/D, 841, 997, TA1, and creates 835, 837P/I/D, 834, 277U, 997, TA1.

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.

PWP-OWA is a PHP-based drop-in replacement for Oracle's Apache/mod_plsql combination, or Oracle Internet Application Server (iAS), allowing for execution of PL/SQL Web Toolkit applications on any PHP-friendly Web server (Apache, IIS, iPlanet, etc.)

Javadoc-like tool for PL/SQL

A class to edit datas in tables from a mysql database with QT toolkit very useful form creation/edition/controls widgets

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

The XACE project, based on Oracle XMLDB and Oracle APEX functionality, is created as a community effort to demonstrate the powerful combination when both Oracle database centric functionality are used in the same environment.

XML to DDL is a set of python programs to convert an XML representation of a schema into a database and vice versa. It can also examine the differences between two databases and emit the ALTER DDL statements required to bring the database up-to-date. T

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.

Script all your database objects and set them into a project within your IDE. This brings the following avdantages: - Manage your database objects properly - Use a VCS to control your database sources - Share these sources between projects - Easy to deploy and generate deployment scripts

Goal of oraschemadoc is to provide detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static xhtml files. There are more features under development...

This project is a PHP-based SOAP server which provides mainly MySQL data to a SOAP client. It exposes all available DB objects (views and tables) to any SOAP client based on NuSOAP's SOAP server.

phpRPC is meant to be an easy to use xmlRPC library. Function syntax, and plugging into most CMS's (xoops, nuke, pn, etc) is greatly simplified with the use of database/rpc-protocol abstraction. It should run on any php server with most databases.

This project is no longer supported. If you're looking for a table API generator for Oracle Database, checkout: https://github.com/osalvador/tapiGen2 tapiGen is a table API Generator for PL/SQL. It creates table encapsulation packages for tables that meet certain criteria. These TAPIs can reduce manual code creation while providing additional functionality for web based apps such as Oracle's ApEx.