The Oracle UNPIVOT clause allows you to transpose columns to rows.
The UNPIVOT clause is opposite to the PIVOT clause except that it does not de-aggregate data during the transposing process.
It’s Very helpful when you are using this under Sub query .
Recent Posts
