Representation of a Query Statement in Oracle 8. Oracle 8 or below doesnt support SQL 92. Join definitions are added to the WHERE clause instead of the FROM clause.
FROM TABLE1,TABLE2 WHERE TABLE1.KEY = TABLE2.KEY
Additionally Oracle has an NLSSortOrder control for order clauses.