Search Results for "oracle database"

A suite of open source utilities written in Oracle PL/SQL for schema instrumentation, auditing, schema administration scripting, ddl mapping and migration code generation, dml package generation, and xml service package generation based on metadata tables

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.

BDComparatista is a set of tools to compare database objects especially the contents of tables as to easen regression tests or reconciliations. It shall provide different flavours for a number of data bases.

A set of utilities and libraries, enhancing standard system PL/SQL packages in the Oracle Database. Attention!!! we moved to GitHub: https://github.com/oramake/oramake-framework Includes: - a utility for creating, developing and documenting program modules in Oracle DB; - a utility for watching the DB size and tracing Oracle sessions ( put pkg_ProcessMonitor.setSqlTrace() before your code and you then receive an email with 10046 events trace file); - logging feature ( similar to log4j, extending limit of PL/SQL Exception message length to 32K); - easy working with files; - flexibly customized scheduler ( similar to cron); - creating Microsoft Excel xml-files; - sending and receiving email messages ( implementation of smtp and pop3 protocols); - a PL/SQL interface for jdbc access ( existing libraries for accessing MS Sql Server, Sybase, DB2 from Oracle DB); - an interface for accessing Subversion; - a utility for parsing CSV and other text files.

A complete database devops solution. It defines continuous integration and continuous deployment process for database application. It makes database application development and release management just like any other code application CI/CD. The software is provided with an easy user friendly UI interface to define the CI/CD for complex database application. Creation of new project, baseline, CI/CD, access management and many other functionalities offer through easy to understand...

TransferWare is a collection of tools for the Oracle world: the schema version manager TransVersion (tv), the External Procedure Call (epc) toolkit for accessing the outside world from within Oracle PL/SQL and an application Performance Monitor (pm).

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.

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/

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.

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

Hades aims to become the reference open source environment for developing, validating and deploying PLUTO (Procedure Language for Users in Test and Operations) procedures.

The BMF is a Software Framework developed in Java language for the creation of web applications on the server platform also Open source, in clinical, administrative and management for a healthcare company.

PL-jrxml2pdf is a PL/SQL-program which takes a report-definition in jrxml-format and generated a PDF-result from it. It's pure PL/SQL, so there's no need for any middleware. Design your reports graphically, e.g. by using iReports from JasperSoft, then use PL-jrxml2pdf as runtime-engine to generate PDF from PL/SQL. The software comes with an Oracle APEX-application whichs installs all required objects and samples. Also the APEX-application allows you - to manage all...

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.

TestMax is integrated Software Testing framework which can be used to test distributed system by developing rapid test cases using XML configuration in front and backend that talks to each other within the test framework. This tool can be used for Database, webservice, API, Junit, TestNg and Frontend including performance test. The main advantage of this TestMax architecture is separating test data configuration from test case run time environment. It reduces the maintenance of test cases...

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

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

Onyx Tools

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

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.

Janox is a PHP-based full cross-tech development suite: > DBMS and platform independent > HTML5-Javascript rich GUIs > Table driven development, no code > Application project full life-cycle management, team-development > Much more..!

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.

SynApp2 builds feature-packed web applications and versatile PDF reports for MySQL and Oracle Database. The SynApp2 web application generator and MVC framework is written in PHP and JavaScript.

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.

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