Tag: pl/sql

Create Internal Sequence to Uniquely Identify Duplicates (Oracle Database)

Step 1: Create Test Table: 

 

Result:

 

Step 2: Run PL/SQLl anonymous block to deal with the duplicates:

 

Result:

Drop All Temporary User Tables in Oracle

PL/SQL Script for cleaning up global temporary tables in Oracle:

 

Dynamic Pivoting in Oracle

Preparing dummy data:

 

Pivoting: