Print Thread
PIVOT
#42639 11/07/11 08:03 AM
Joined: May 2005
Posts: 7
South Africa
R
Ruby Offline OP
Member
OP Offline
Member
R
Joined: May 2005
Posts: 7
South Africa
Apparently there are new PIVOT/UNPIVOT functions in Oracle 11g. Can someone please give me a working example?


Thanks,
Ruby

Re: PIVOT
Ruby #42641 11/07/11 10:13 AM
Joined: Jul 2004
Posts: 24
Germany
H
Member
Offline
Member
H
Joined: Jul 2004
Posts: 24
Germany
Already tried to search the net?

simple one e.g. here:
http://www.orafaq.com/wiki/PIVOT
http://www.orafaq.com/wiki/UNPIVOT


regards

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.043s Queries: 14 (0.014s) Memory: 2.4978 MB (Peak: 3.0428 MB) Data Comp: Off Server Time: 2024-05-18 21:44:28 UTC
Valid HTML 5 and Valid CSS