Search Results for "sample"

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;

This is a small mysql query builder using the nodejs mysql driver by felixge. 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. ...

...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 multiple languages aligning all technologies used by a development team. If you are willing to contribute drop a message.

RepMiner takes a graph theory approach to the classification and assembly of the repetitive fraction of genomic sequence data. Sequence lengths analyzed by RepMiner can range from full length transposable elements to low coverage sample sequence data.

This is a sample implementation of the TransQuery processing model, enabling the use of XSLT as a query language over multiple XML documents. See <a href="http://www.xmlportfolio.com/transquery">http://www.xmlportfolio.com/transquery</a> for more info.