From a column that appeared in Database Programming and Design in the August, 1998 issue.
Populating the table (restricted scenario) in DB2 Populating the table (general scenario) in DB2 Examples in DB2
Examples in Oracle