Skip to Main Content

create pivot in pl/sql

user10316500Nov 19 2015 — edited Dec 12 2017

Hi

I tried using PIVOT functionality in PL/SQL 11g but it's too limited for my queries.

I have to create complex queries.

At the moment I use sum(decode(...),rollup, grouping ecc.... to pivot columns.

Is there an other functionality in PL/SQL or a Java Class to call from PL/SQL (CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED....) ?

Stefano

Comments
Post Details
Added on Nov 19 2015
9 comments
1,745 views