Comments
| PIVOT and UNPIVOT Operators in Oracle Database 11g Release 1 - Learn how to use the new PIVOT and UNPIVOT operators in Oracle Database 11g Release 1. |
Big George said... Cool :) |
Cva said... Very nice feature in 11g and well explained in few mins. Earlier i had a situation for Pivot where i happened to use multiple queries for each column which was bad :)Anyways excellent information. Thanks Tim ! Appreciate your postings. |
J. said... Great article, well explained. thanks for hightiting this new feature.J. |
Ashish said... a very well written article.Ashish Oracle Diary<>/a |
Snoopy said... That´s cool but what if you have two more columns, price, (quantity * price) as total? |
Tim... said... Hi.Not sure what you want. Ask the question in the forum and give an indication of the expected output. Cheers Tim... |
Rakesh said... Was Dieing to do this in 10g without any direct function. |
Aditya Singh said... I am trying pivot method to implement in PHP but its giving some error.Table is clientdetails with 3 attributes (clientname,productname,quantity). select clientname, 'Software' as s, 'Desktop' as d FROM ( select clientname,productname,quantity FROM clien |
Tim... said... Hi.Please ask questions in the forum. Provide relevant CREATE TABLE and INSERT statements for the test case. Cheers Tim... |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!