Tome Kyte has good examplesat http://asktom.oracle.com, including this one