(Select nvl(D.Name,'NULL') Doctor, nvl(P.Name,'NULL') Professor, nvl(S.Name,'NULL') Singer, nvl(A.Name,'NULL') Actor (Select Name, row_number() over (partition by ...