I just want to share my scenario with department table, as this is showing right now 3 column as i have only 3 department. However, i want maximum 10 column to be displayed if any department missing
from 1 to 10 deparment then missing department also to be shown.
select *
from table( pivot_fun(' select deptno
, job
from emp
')
)
This is current Output

Desire Output
