DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PIVOT TABLE

  1. #1
    Join Date
    Jan 2001
    Posts
    50
    this may sound very simple..............
    i came across the PIVOT Table can anybody tell what exactly is ths table its structure and what exactly is it used for.??
    Aniruddha Gupta

  2. #2
    Join Date
    Feb 2001
    Posts
    180
    I haven't heard of it yet within oracle, but if you have
    Ms Excel then look there in the help about pivot-tables
    Regards
    Ben de Boer

  3. #3
    Join Date
    Apr 2001
    Posts
    51
    example of a pivot table

    select job,
    count(decode(deptno,10,'Deptno 10')) "Deptno 10"
    ,count(decode(deptno,20,'Deptno 20')) "Deptno 20",
    count(decode(deptno,30,'Deptno 30')) "Deptno 30"
    from emp
    group by job

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width