Question : I need to aggregate the contents of multiple rows into a row as a delimited text. Here’s the […]
Tag: h2
Will Derby, H2, or SQLite give faster load time and/or smaller file size than HSQL?
Question : I have some flat files with the following columns; 3 integers, 3 reals, and 1 varchar(20). For querying […]
Application testing: using multiple users in Oracle instead of mem H2. How to make it as fast as possible?
Question : I decided to stop using H2 for obvious reasons (I have Oracle on production, compatibility mode is a […]
Alternatives for a LEFT OUTER JOIN query
Question : Problem I have a SQL statement with an LEFT OUTER JOIN which works fine on our Microsoft SQL […]