Break out the book on SQL functions and read about instr and substr.

http://download-west.oracle.com/docs...s55a.htm#77600

http://download-west.oracle.com/docs...119a.htm#87068

Give it a try on your own first, and tackle it in bits and pieces. Use "select (your use of instr and substr) from dual."