Search Results for "oracle sql monitor"

This PL/SQL package converts a query with a sdo_geometry into an ESRI shape file and a shape file into a Oracle table. It can also convert a Oracle table into a dBase file and vice versa. Sample 1 - create a shape file (alk.shp, alk.shx, alk.dbf) of type 5 (=Polygon) from table MYTABLE with sdo-column="geo" and SDO_GTYPE=3003: select zvk_shape.write_shp('DATA_PUMP_DIR','alk', 'select t.C01 "NAME", t.C20 "FLST", t.GEO from MYTABLE t where t.C02 = ''ALK'' order by t.C01','GEO',5) "alk" FROM dual;

In the Oracle database there are two PL/SQL APIs to send mails: UTL_SMTP and UTL_MAIL. But there is no package which is able to retrieve messages from a mailbox on a server. The here provided package MAIL_CLIENT closes this gap.

Kokpit-db is an integrated monitoring, comparison and performance analysis software for Oracle databases. It can compare and monitor versions 8i, 9i, 10g and 11g. Supports standby databases and ASM instances. GUI and command line interfaces available

An Oracle client library written purely in Pro*C (Oracle C precompiler for embedded SQL). Implements Pro*C ANSI dynamic SQL and provide APIs to application programs by hiding ANSI dynamic SQL directives. Designed to be portable across platforms

This program can help you to connect to the SQL server and execute queries, inserts, updates, show results, browse through DB schemas, tables. It has converter from timestamp date to regular date format and vice versa + Backup and Restore of MySQL DB + export to CSV file. Not need to install, just launch and use. Program was created with Java 1.7 version, please, use the same version for launch it.

Debby has replaced CDE in the Tina4Stack, you may want to check it out at http://tina4.com CDE is a PHP class which implements the general database functions in PHP and provides a common SQL platform for php development where developers change their databases but not their code. Supports Firebird, MySQL,Oracle,SQLite, MSSQL(both drivers),CUBRID,ODBC. CDE now supports date uniformity, param passing & BLOB handling across all the databases supported. CDE is not a replacement for PDO, in fact we may implement PDO in CDE to standardize PDO results and calls. ...

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

TPCCRunner is a TPC-C Like workload generator, used to test Online Transaction Processiong Database System. TPCCRunner supports most of popular RDBMS: Oracle, DB2, SQL Server, MySQL, Informix, Sybase etc.

it is an emulator for making sql like behave like an odbms with an rdbms, it supports oracle, mysql, firebird and any other database, it is written in java.

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.

PL/SQL packages to perform Oracle 11g tasks within a very few number of lines : dump/load LOBs, compute CRC, get Mime Type from a BLOB, send XMPP messages, list directory contents as a table, interact with Twitter,deal with QrCodes, ...

DBPrism is a framework to generate dynamic XML from a database, it provides an high performance DBGenerator for Cocoon2. Also is a J2EE replacement for Oracle mod_plsql. This project also includes a Restlet-Oracle connector exam. and Lucene Domain In

Open-jACOB is a rapid application development tool base on Eclipse that enables the development of RichInternetApplications that are based entirely on Java. Open-jACOB application can be deployed as a stand alone app's in a Web container like Tomcat.

Sequoia is a database clustering middleware offering load balancing and transparent failover. Databases are replicated over multiple nodes and Sequoia balances the queries between them. Sequoia supports online maintenance and recovery operations.

Orate is a source-level tracing facility for Oracle PL/SQL. Programmers insert calls to Orate in the code and Orate captures and writes run time information to a table. These data are suitable for debugging, testing and profiling the application.

The Simplified Heuristic Export/import Management Program (SHEMP) provides a simple, table-driven framework that implements data exports, data imports and reporting for Oracle databases. SHEMP exports and imports in multiple file types, including Excel.

SQL2JAVA is a SIMPLE, PRAGMATIC and POWERFUL code GENERATOR. It maps any relational schema to a java API dedicated to access your database schema. It supports Oracle, SQLServer, PostgreSQL, MySQL, Sybase, HSQL, etc... 2 minutes to install/try...

Full featured AJAX web based reporting system. Written in Java / JSP. Web based reports are dynamically generated from JDBC result sets. Connects to any JDBC compliant database, most drivers already included. The Apache Derby database is embeded.

SQLGotcha helps you to find sessions in an Oracle database that you want to trace. Search for logged in users, OS users, Unix PIDs, a user's machine or the program that started the session.

DB Guardian is a Java-based database diagnostic performance tool for Oracle 10g. This tool helps the database administrator (DBA) to monitor and detect problems related to performance in your environments.

JXmlSql is a Java database API ( MySql, Oracle, Access )that eliminates JDBC code. JXmlSql allows developers to define application and prepopulation SQL statements inside xml files. Options for query, insert, update, delete, report and prepopulation SQL.

Framework that uses a subset of SQL and provides php developers an alternative solution to tables and atabases, particularly those who do not have a database service (like mySQL, SQLite, MSSQL, ORACLE...). Comes packaged with an txtSQLAdmin.

Have you ever wondered which database indexes you should create for your JDBC-based application ? This Swing-based SQL profiler tries to offer a tool to monitor which tables and columns are accessed the most in SQL queries to recommend index creation

SQL_AL.PHP™ is a PHP library providing a single, unified interface to multiple RDBMS types. SQL_AL.PHP is a free, open-source API with support available for Firebird SQL, Interbase, Microsoft SQL, MySQL, Oracle (OCI7/8), PostgreSQL, and Sybase.

jUDO (java Universal Data Objects) handles coding against a database Independent of database (plugins for db2/Oracle/Cloudscape/mysql/mysql etc).The code is generated "runtime" , just give the method names and jUDO derives the code/sql.