I use Oracle 8 and 9 databases.
There are differences against VFP in SQL syntax.
For example:
When I use clause ORDER BY, I can't use numbers, but I must name all! non aggregate fields listed in 'fields' clause (and they can't be Long=memo datatype).
Clauses like TOP are coming in version 9 with RANK().
First differences between 8 and 9:
SUM() on numeric NOT NULL fields returns NULL datatypes (0 in ver.8 - so I add NVL()).
COUNT(field_name) in SELECT with difficult clauses WHERE are very slow (so I rewrite it to count(*)).
Pavel