Some vaguely structured thoughts on the differences that you see between SQL as implemented by one DBMS and that of another.
Have you received the following error:
Accessor is not a parameter accessor.
This is from an ASP application running against an Oracle database. Here is how I fixed this problem in my application:
The problem was due to excessive digits in a number being returned by an Oracle SQL SELECT statement. To fix it, I changed the SQL statement so that it used the Oracle ROUND function to remove some of those digits, e.g.:
SELECT fees / days
SELECT ROUND(fees / days, 3)