Database Validation Queries

The following SQL statements are database specific validation queries which are typically used to verify that a client can connect to a database.

MySql, Microsoft SQL Server, PostgreSQL, Ingres, Derby, H2
select 1

Hsqldb
select 1 from INFORMATION_SCHEMA.SYSTEM_USERS

Oracle
select 1 from dual