SQL & PL/SQL

Hello all!

I want to "de-normalize" two tables into one for presentation reasons. For example:

CREATE TABLE foo(id number)

CREATE TABLE bar(foo_id number, value varchar2(4))

And with some data:

FOO:
------
1
2

BAR:
-----
1, 'gaz'
1, 'boz'
2, 'blah'

Now I want to create a view that holds the value of the BAR table in a nested table, if possible and efficient enough..

VIEW:
------
1, nested_table('gaz,'boz')
2, nested_table('blah')

Any clue for creating such a view? I would prefer a view, because this view will be joined with other tables later.

Thanks in advice!