Search Results for "dump sql 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;

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

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.

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

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.