Search Results for "oracle sql query builder"

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 program can help you to connect to the SQL server and execute queries, inserts, updates, show results, browse through DB schemas, tables. It has converter from timestamp date to regular date format and vice versa + Backup and Restore of MySQL DB + export to CSV file. Not need to install, just launch and use. Program was created with Java 1.7 version, please, use the same version for launch it.

JXmlSql is a Java database API ( MySql, Oracle, Access )that eliminates JDBC code. JXmlSql allows developers to define application and prepopulation SQL statements inside xml files. Options for query, insert, update, delete, report and prepopulation SQL.