I need to write a query which will be run against SQL Server and Oracle. A query just selects a constant.

In SQL Server, I can do this:

SELECT 1 AS Value;

And in Oracle:

SELECT 1 AS Value FROM DUAL;

But the database is not known at runtime. Is it possible to have one SQL query for both DBMS?

Queries above work fine, but I need to unify the syntax.