Running:
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production

Our software currently runs against SQL SERVER, DB2 & INFORMIX.
I am now in the process of porting it to ORACLE.
We make heavy use of SQL and 99% of our SQL runs across all vendors unchanged.
This has been possible through the use of the ODBC canonical {fn ...} functions.

For example - SUBSTRING :
select {fn SUBSTRING(mycolumn, 1, 5)} from mytable

This works across SQL SERVER (SUBSTRING), DB2 (SUBSTR) & INFORMIX (SUBSTR).

There are lots of other {fn} functions - NOW, TIMESTAMPDIFF, MONTHNAME, YEAR, etc, the use of which means no code branching is required.
From my initial investigation it seems the ORACLE does not support the {fn ...} syntax - is that correct?

I hope it isn't as branching each SQL statement is nightmare city.

thanks for any help on this.

Andy