Pubudu Dewagama

T-SQL : How to Pivot in the SQL Server table using T-SQL.

In my previouse post i have explained, How to pivot data with PL/SQL. Here i’m using SQL server table and T-SQL to Pivot data.Pivot query h...

T-SQL : How to Pivot in the SQL Server table using T-SQL.

Reviewed by Pubudu Dewagama on 10:19:00 PM Rating: 5

When we have data in row based we have to convert it into column base. for that we can use pivot machenaism in PL/SQL. in this post i’m goi...

PL / SQL : How to Pivot data in the oracle table.

Reviewed by Pubudu Dewagama on 2:57:00 AM Rating: 5

Step 1: To create source execute the below table creation script and use insert statements for load data to Employee Source table. Source...

PL/SQL : How to load data from oracle table to table using PL/SQL script

Reviewed by Pubudu Dewagama on 9:50:00 PM Rating: 5

Pubudu Dewagama 10:10:00 PM

Step 1: Open you Tableau application. Step 2: Go to datasource Tab and select the Data sources. In here im using Tableau sample Excel s...

Tableau 9.3 :Create Hierarchies for Drill/Down option

Reviewed by Pubudu Dewagama on 10:10:00 PM Rating: 5