Search Results for "sql table"

Beekeeper Studio is an open source, cross-platform SQL editor and database management app that is both powerful and easy to use. It lets you query and manage your relational databases, with support for connecting to SQLite, MySQL, MariaDB, Postgres, SQL Server and Amazon Redshift databases. Unlike most other open source SQL editors and database managers, Beekeeper Studio isn’t cluttered with unnecessary features, but does come with the essentials that you need. This includes SQL auto...

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

...Sample Usage: ```js var query_builder = require('query_builder'); var dbconn_default = { host : 'host', user : 'user', pass : 'password', dbase : 'database_schema' }; var qb = new query_builder( dbconn_default ); var select_details = { table : 'table_name', fields : [ 'field1', 'field2', ... ], conditions : { field1 : 'value1', field2 : 'value2' } }; qb.select( select_details, function( err, rows ){ if( err ) console.log( err ); else console.log( rows ); }); ``` By this, we can generate a query something like this: ```sql SELECT `field1`, `field2` FROM `table_name` WHERE `field1` = 'value1' AND `field2` = 'value2' ``` For more information, visit the github project. ...

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

A fast performing utility application written in C# .net 3.5 for data administrators or developers working with SQL Server. See features and screen shots for more information. This utility application works with SQL Server 2005 or SQL server 2008.

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.

MyDBemu is a C++ Library which provides a 'database table'-like Data Type, and methods of data management in a SQL thought.