Search Results for "sample database"

Just use the portable copy of the free sqlitebrowser program, available here : https://sqlitebrowser.org/dl/ to open and test the sample db, that I have given as a download here ( after extracting the zip file ) . Also, I have enclosed, the csv files, that I have used for importing and exporting, from the file menu of the program. Also, watch the video below, for a quick start. Tags: Learn SQL Quickly, Analyze Data Easily, SQL Guide, SQL Samples

Now also living on gitlab. https://gitlab.com/mds-/xplordb Mineral Exploration Database template/ system for Postgres/PostGIS and QGIS. The project incorporates import scripts, data storage, validation, reporting, 3D drill trace generation and more. psql, pgAdmin and QGIS are the suggested database and GIS front-end programs.

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

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

Sample applications created on Oracle Application Express

HIPAATalk - Contains stored procedures and sample DTS packages for parsing and converting X12 to flat tables and creating HIPAA-compliant X12 files. Currently reads 820, 834, 835, 837P/I/D, 841, 997, TA1, and creates 835, 837P/I/D, 834, 277U, 997, TA1.