Search Results for "select"

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

Flat-file SQL (fSQL) is a set of classes available in PHP that allows users without SQL database servers to select and manipulate flat-file data using SQL queries. fSQL is designed to support as many SQL queries and features as it can.

Document Object Model Structured Query Language! Example: 'SELECT {//title[1]=>innerCode} FROM {http://example.com}';

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

Change the encoding and collation of mysql databases on the fly. Clean html characters from your database, change the database storage engine, select collation type or convert text to UTF-8 or any other encoding. Completely configurable filter options. This script primarily useful in database migration and changing your database to finally support UTF-8 and other encoding types.

...Java client applications can connect from dynamic or static IP's safely using the SSL protocol (plaintext is also supported). To help optimize network connection usage, SELECT queries sent as a batch CAN be returned in a single pass. The additional resultsets are accessed using the standard JDBC Statement.getMoreResults() to iterate and Statement.getResultSet() to consume each additional Resultset in the results. This feature can help improve client application performance when running multiple select queries in a row.

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

XBSDB is the tool to operate with data in JavaScript code like with SQL-data. XBSDB stores, arranges and selects data in your scripts. You can insert, delete, update and select records, you can use indexes. JSON-based methods allow data exchange.

This class provides some methodts - to easily get results forom SQL-Queries as Array, Hashtable or Value (e.g. SELECT MAX(..) FROM ..) - To insert, update or delete records - It works together with my other Library stdfuncs (PHPCoreStdFuncs in SF)

It's a script that read sql "select" request from postgres 8.1 logs and generate for each request all the index to optimize the database. Tested on 1.2 GB of logs.

Imagine this sql SELECT DIFF(f1.*,f2.*) FROM `/ws/src/test` f1,`/ws/src/test/.svn/text-base` f2 WHERE f1.filename=CONCAT(f2.filename,'.svn-base'); F8QL is about mapping filesystem as db, F(S slashed)QL is a jdbc compliant API patterned on mysql queries

RBFF is a JDBC driver for being able to easily view and execute simple select SQL queries against a record-based flat file (such as EDI files, or other proprietary legacy files)