Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    8

    Unanswered: Pivot and CrossTab Queries.

    Hi,

    I have an Attendance table like...

    Course_id Course_name Course_hours
    1 ABC 05
    2 DEF 08
    3 GHI 06

    and so on....

    Now here the Course_name and Course_hours columns have indefinite data entered by the user. It may be 3, 4,10,20 courses along with its hours....

    I tried the DECODE method but i guess it can handle only definite data.....

    Any idea to turn the Indefinite Rows into Coumns...?

    Please help me with this...


    Thanks in advance....

  2. #2
    Join Date
    Mar 2010
    Location
    Vienna, Austria
    Posts
    149
    Why not using the "PIVOT" clause of the SELECT statement ?
    "There is always an easy solution to every problem - neat, plausible, and wrong."
    -- H.L. Mencken

Posting Permissions

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