http://snipplr.com/language/xml/tags/database Recent snippets posted on Snipplr.com en-us Sat, 11 Oct 2008 06:09:32 GMT http://snipplr.com/view/2205/load-csv-data-into-a-database/ This example demonstrates usage of Scriptella ETL Tool to load CSV data into a database table.

]]> Fri, 23 Feb 2007 13:51:21 GMT http://snipplr.com/view/2205/load-csv-data-into-a-database/ http://snipplr.com/view/2204/copy-table-from-one-database-to-another/ This Scriptella ETL script copies all rows from Src_Table to Dest_Table. Src_Table contains the following columns: id, first_name, last_name Dest_Table contains the following columns: id, name The name column of the Dest_Table is produced by a concatenation of first_name and last_name from the Src_Table This example demonstrates HSQLDB-To-Oracle copy procedure, although it works between virtually any databases.

]]> Fri, 23 Feb 2007 13:49:49 GMT http://snipplr.com/view/2204/copy-table-from-one-database-to-another/ http://snipplr.com/view/2203/etl-script-to-insert-blob-from-file-into-a-database/ Scriptella ETL allows inserting files into a database. This is achieved by a simple bind variables extension syntax ?{file ...}. The following sample initializes table of music tracks. Each track has a DATA field containing a file loaded from an external location. File song1.mp3 is stored in the same directory as etl.xml and song2.mp3 is loaded from the web:

]]> Fri, 23 Feb 2007 13:46:53 GMT http://snipplr.com/view/2203/etl-script-to-insert-blob-from-file-into-a-database/