Blog / PL/SQL

oracle unpivot function

Amit Kumar 1 min read

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 .

documentation docx :oracle_unpivot

Documents

Related blogs

Oracle Application Blog

Preventing Duplicate Form Submission in Oracle APEX

Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally clic…

Akthar Basha 2 min read
Oracle Application Blog

UI Mistakes Oracle APEX Developers Should Avoid

Introduction / Issue Many Oracle APEX applications successfully meet business requirements but often overlook one critical aspect—the User Interface (UI) and Us…

Akthar Basha 3 min read
Oracle Application Blog

WIP Job Close via Apex Application

Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming t…

Sivaguru Karunanidhi 6 min read