|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Select and subquery
Emulating a table with sql
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
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.
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.