Rotating data with Oracle views

Hi folks,

anyone got a clue how I could solve this one???

I have a table in oracle 10 like this:

user   att_name  att_value   updated
doug  age           36            16/10/2001
doug  extn          2134         18/01/2002  
doug  user_id     tts447        16/10/2001
fred   age           18             16/02/2001
fred   extn          2289          26/10/2003
fred   user_id     tts301        16/11/2001
fred   reg           j409ssr      06/10/2001
john  age           22             16/12/2000
john  extn          2345          11/10/2001    

It gets one row, for eace 'user' for each 'att_name' attribute. So doug gets three rows, one for age, one for extn and one for user_id.

Now I nead to gather this data together, and swing it round in a view (possibly using other sub-views) to make it much more useable. So I need to get something like this:

user    age  extn    user_id   reg
doug   36    2134   tts447  
fred    18    2289   tts301     j409ssr
john    22   2345

(I'm not remotely interested in the updated column)

Therefore, I need to collect the various records together, and populate one column for each of the attributes.

Now, some conditions:
1. Each user has a variable number of attributes. So, not all of the columns in the view will be populated for each record.
2. If possible, I'd like to know how to create these column names in the view 'on the fly'. The system is open, so I have no control over what any of the att_name's will be. So I need the view to be able to create columns based on the various names that are in the att_name column.

Has anyone got a clue how to approach this? I'm stumped.

Cheers,

Hal.