Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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...

ashish said...

If there are more column need to convert in Pivot
then how to add the columns in SQL query?
Above given example s for one query


Tim... said...

Hi.

Not sure what you mean. Please ask the question in the Forum and post the CREATE TABLE and INSERT statements to set up a test case.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

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!

Add your comments here.
Name
Comment
(max 400 chars - plain text)