Hello,

I am a newbie in oracle, just wondering how to extract this tables.
here is the records in a table look like

acc_id year amt

001 2004 25.5
001 2005 30.0
001 2006 1.5

002 2002 1.25
002 2003 6.0
002 2004 3.5

003 2010 10.00

they want me to extract in csv look like this.

acc_id 2002 2003 2004 2005 2006 2010
001 25.5 30.0 1.5
002 1.25 6.0 3.5
003 10.00

Thank you.