Oracle SQL

Mathematical

Aggregate functions allow to group "equal rows" in a result set and to do some (mostly mathematical) operations on a column of this group.

Hints

Model clause is an extension in 10g.

Regular expressions are definitely going to be very cool.

This SQL validator can obviousy be used to check if an SQL statement is valid SQL-92 according to the standard. I haven't checked it out yet, though.

Thanks to Prasad Godavarthi and Philippe Antoine who each pointed out a wrong links on this page.

Thanks also to Olivier Holl who notified me of a typo on this page.