René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Oracle SQL

Mathematical

Date related

Analytical Functions

Select and subquery

Shorties

Emulating a table with sql

Aggregate functions

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

User defined aggregate functions in 9i

NULLs and boolean operators

insert into x returning y

hints

Model Clause

Model clause is an extension in 10g.

Regular Expressions

Regular expressions are definitely going to be very cool.

Validating SQL 92

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.

Misc

Thanks

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.