-
Display a rows horizontaly dynamically
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|