Open Source PL/SQL Software Development Software for Linux

Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets.

BladeX is a well-designed microservice architecture that provides a full set of SpringCloud solutions. Open source China's first batch of microservice architectures that perfectly integrate SpringCloud Alibaba series components are upgraded and optimized based on stable production commercial projects, and are closer to enterprise-level needs. Pursuing enterprise development More efficient, easier to deploy, and more stable. The multi-tenant architecture that meets the Chinese-style needs supports flexible combinations of multiple modes such as multi-tenant-one database, one-tenant-one database, and multi-tenant multi-database. The system provides three configurations of menu button authority, data authority, and interface authority. The combination configuration method based on annotation + Web is flexible and takes effect immediately. Deeply customize the Flowable workflow to meet SpringCloud distributed scenarios, escort complex processes, etc.

!!! NOTE !!! The latest file upload (Simple.zip) is a simplified version of the Starter Framework meant for single-schema applications. It only offers logging, error handling and table-driven parameters (with a few extra supporting packages for writing to screen and file, and manipulating dates, strings and numbers). In order to access the simplified framework, click "Browse All Files" and choose the plsqlfmwksimplet folder, then the 2.1 folder. Download Simple.zip. The full framework (Starter_Full_2.0.zip) is meant for multiple applications resident in multiple schemas on the same database, where the common framework is shared between them all. It is a collection of PL/SQL packages and related tables, which provide a starter framework for custom PL/SQL-based applications. Save months of design/build time. Includes logging, debugging, timing, locks, common messages, file reading/writing/management, email from within the DB, user/role security, and more.

"It's not a tool, which fixes a problem, but the fool using it!" (Jörg Stryk) The M7 bunch of scripts should help the EXPERIENCED Troubleshooter to quickly identify bottlenecks and to develop/implement appropriate solutions. "With great power comes great responsibility" (Uncle Ben)

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.

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.

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

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.

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.

A set of Java classes to enhance and speed development with Oracle Applications Framework, Oracle's MVC Framework for web application development for Oracle E-Business Suite R11 and R12. To be kept up-to-date with any changes to the Toolkit please either subscribe to the Notifications below or join the Maillist

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.

This software provides PL/SQL packages for defining and measuring business tasks utilizing Oracle's extended SQL tracing mechanism.

DSP stands for Data Server Pages, the APACHE HTTP server module, that provides PL/SQL Server scripting with variable injection preprocessor and features an efficient authorization and authentication framework on the Oracle database backend.

Javadoc-like tool for PL/SQL

This project will add support for editing Oracle PL/SQL objects right inside the NetBeans IDE, including syntax highlighting, code folding and indentation. See Wiki for more information.

ANY Database employing SQL, any system, any task TRANSFORM Your SQL between DBMS, different languages and from slow SQL to fast one, transform any of Your redundant task to work in organized and sustainable manner.

Mar 2025 - Project moved to Github: https://github.com/symbolthree/apex2ebs APEX2EBS is a framework to integrate Oracle Application Express (APEX) and Oracle EBS 11i or R12. Developers can quickly create professional web-based applications in APEX which interacts with Oracle EBS with equal level of access controls.

Project discontinued

Framework to enhance Oracle APEX (Oracle Application Express) on the client (browser) and server (database). To unleash the full potential of ApexLib also use the Oracle APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/

Developed for C++ development environement , inspired by Java Persistence library. foralldb will provide object-relation mapping to multi-vendor database systems.

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/ .

Catnap is a lightweight Java persistence layer which stores and retrieves objects from an Oracle database using PL/SQL packages.

.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.

DBBinder++ is a data-binder/ORM tool for SQL Databases (SQLite, MySQL, Firebird, Oracle and possibly others). Given an input file which contains severall SQL commands, it will generate source code to easily acess the results.

Elvyx is a tool designed to monitor and profile the jdbc activity on java projects. This jdbc profiler has a server with a built-in db and a client to improve the experience.