The SQL MODEL clause was introduced as a new feature in Oracle 10g. Mark Rittman has a good article about how to use the new clause to generate financial statements.