Search Results for "table"

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

This package provides logging functionality inspired by log4j for Oracle database. Logging is done to dbms_output and into a specific table.

CrystalDB Tool is used by developers, DBAs and analyst for managing, administering and developing databases. The utility supports the two common database management system, namely MS SQL Server and Oracle. It provides an editor that offers code completion and syntax highlighting for standard SQL. It features a connection browser and a comprehensive set of database administration tools.

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;

SQL Script Generator is a SQL code generator database building tool, aiming to reduce time of coding and debugging, speed up projects, reducing human errors and avoiding repetitive tasks. The initial goal of this prject was to to demonstrate basic coding structures, Visual Basic Language, SQL, .NET WinForms theming .

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

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

This is a set of PLSQL packages for the Oracle database which provide acess to the OS shell and the file system from SQL and PL/SQL. The packages provide operations on file handles (delete, create, move, copy) as well as the execution of shell commands.

Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements. These files can then be u

Saves Time and Money. Oracle Table API Generator written in PL/SQL It Generates database procedures or functions for insert, delete, update, select and refcursor for one or more tables. Configurable for parameter names and what/how the code is generated.

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

"Tiny Oracle Get" is a Oracle DB GUI tool on Linux/Windows for developers. It supports DB browsing, comparison of SQL results, DDL output, drawing ER-diagram automatically, Excel friendly interface with multi-Language.Required Oracle Client and Qt4

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

Github repository: https://github.com/miguelaxcar/PHP-MSSQL-Server-Admin Web based tool written in PHP by Luiz Miguel Axcar to build and run queries on a remote or local MSSQL (Microsoft SQL Server). Support for SQL code highlight (!), table browser, field browser, TOP records, most used tables, CSV results export, etc. Most tested in SQL 2000 version. If you find some issue ther let me know and I help you fixing it.

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.

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.

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.

This project can be applied to any Microsoft SQL Server database. It creates generic change logging triggers on selected tables, which will log all changes to a single log table.

CHADDB,the CHurch ADministration Database, is a Java/MySQL-based, table-driven church managment system that enables churches of any size or structure to manage members through relationships. Web-enabled or run as native application.

A web page parser for sql written in java. It breaks html into table rows. It can datamine dynamic tables and alert a user to trends. It interfaces with authenticated & search sites. It is very flexible, uses selfmoding code, and can do http push

Oracle PL/SQL Code Generator for Table Encapsulation that would handle all DML operations. It would generate production level code for a table that could be incorporated in any application.

CdBase is a front-end for PGSQL. It grep the cdlabel and contents to maintain a database. Fully configurable, it create the db and the general table; each cdrom has its own table in relation with the generic table.