Dec 14 2011, 06:36 AM
Hello, I´m trying to list the products list of a client grouped by type of the product. Ex:
I want to list something as:
Is it possible?
Dec 14 2011, 06:54 AM
>> I´m trying to list the products list of a client grouped by type of the product.
Sure!It looks like you want to pivot multiple row values onto a single column, right?http://www.dba-oracle.com/t_converting_rows_columns.htm
If you want more working examples, get the code download from the book "Advanced SQL Programming":http://www.rampant-books.com/book_0802_adv...programming.htm