Oracle Apps

Using PIVOT Sample Sql  SELECT         accounting,         research,         sales,         operations     FROM         (             SELECT                 dname             FROM                 dept         ) PIVOT (             MAX ( dname )             FOR dname             IN ( 'ACCOUNTING' AS accounting, 'RESEARCH' AS research, 'SALES' AS sales, 'OPERATIONS' AS operations )         );