Open Source PL/SQL Software - Page 29

Optimal Solution WMS

This project aims at creating an open source chemistry plugin / cartridge for the relational database system Oracle. Free Oracle chemistry cartridge.

The Ora-Logger application is an advanced logging system for Oracle. It provides the ability to code logging statements into source at various levels of precedence. Once the code is compiled, the output levels can be increased or decreased on the fly.

ORACLE PL/SQL development framework including coding standards and summarizing third-party tools like pldoc, ant, log4pl and utPLSQL.

OraLog is a logging framework for Oracle databases. It allows Oracle developers to log debug information from their PL/SQL code and to send them to various destinations by using log appenders.

OraMail - mail system based on oracle

For Oracle database, mask sensitive data by replacement (static or expression), substitution (synthetic data set is included), random values (Lorum Ipsum) or deletion. Generates update/delete statements or triggers or runs directly against the database.

The OSM is a complete set of Oracle diagnostic tools based upon response time analysis. It also contains an hisotrical analysis pack which is much better than Statspack (e.g. it collects and reports on OS stats). The OSM is sqlplus based and non-graphic.

SVN Version Control your Oracle Sources directly with PL/SQL.

OraTS: Oracle Template System. A HTML::Mason like template system based on Oracle 9i server technology. Provides fast, component-based web authoring environment using PL/SQL programming language.

Set of scripts for managing Oracle Database 9i through 11g.

A starter application developed using Apache Wicket and Oracle. The software is database specific, exploits Oracle functionality and is based on Oracle's published recommendations of best practice.

Web application built using: a. Spring Webflow 2 b. Oracle (10G +) It implements commonly required functionality and is intended to act as a strong starting point for any web based business application.

Oracle Database Monitor based on APEX 4.1. Database Monitor Functions: - Instance - SGA - PGA - DB Parameter - Buffer Pool Keep Candidates - Version and Patches Realtime Monitor - Locks - DDL Locks - DML Locks - Library Cache Lock - Waiting Library Cache Pin - Session Browser - SQL Statements - Temp Usage - Bind Variables - SQL Statistics - Segment Statistics - Index Segment Statistics - Session Long Operations - PGA Memory Usage Objects - Tablespaces - Segments - Objects - Indexes - Extents - Total Table Space - Waste Space APEX - Activity - Report for Apex Mail Log - Report for Apex Mail Queue Jobs - Scheduler Jobs - Scheduler Job Log - Scheduler Job Run Details

The Oracle application framework library is a collection of standard, proven frameworks to assist developers in quickly turning out some quality application features including custom exception management, application config, session tracing, email.

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

This is an Oracle EM management plug-in for MySQL. It can be used to monitor MySQL database in OEM environment. We are also on Google Code: http://code.google.com/p/mysql-emx/

Oracle ETL Toolkit is some packages for developing Oracle ETL Application, The first release will include a OET_Scheduler ,a simple procedure scheuler.

The Oracle ExcelDocumentType project provides an open source Oracle PL/SQL user defined type and utilities designed to generate fully functional Microsoft Excel spreadsheets from within the database. The code generates Excel XML data.

This Oracle Forms Framework is designed for Forms Developers, who start creating a new application and need help in establishing style guides, templates or prototypes The new location is : http://code.google.com/p/forms-framework/

Oracle does not support the SQL standard INFORMATION_SCHEMA data dictionary. This project creates an information_schema schema and adds views compliant to the SQL standard. These views are SQL and PL/SQL and are built on the Oracle data dictionary.

A jdbc dblink implementation, that allows to create jdbc links between oracle and any other jdbc reachable database, to launch query by sql and pl/sql or execute remote store procedures. This allows also to reach an Oracle 7.3.4, from a 10.2.0.

A light-weight, simple to use, fine-grained Oracle PL/SQL logger utility allowing you to see the desired output at crucial points in your code. Set your logging level globally, for a specific package, procedure or function. Create logging entries independent on your transactions and without a need to recompile your code.

AnalysesOracle Performance Doctor is a tool which helps you to understand the behavior of your application on Oracle database level. The tool does: 1. Extract execution plan for all SQL’s executed by specified db user and print it to file on server side. 2. For all executed SQL statements the tool will provide more performance version of sql text by using built-in module dbms_sqltune.

Send XMPP (Gtalk/Google Talk also supported) messages (thanks to Jabber) within a single line of PL/SQL code, get buddies list and status in relational tables (or xml) on Oracle 11g.