General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only