1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need advise on converting the x axis and y axis into oracle table

Discussion in 'SQL PL/SQL' started by Shanmugapriya, Apr 16, 2018.

  1. Shanmugapriya

    Shanmugapriya Active Member

    Messages:
    55
    Likes Received:
    0
    Trophy Points:
    130
    Location:
    Bangalore
    Hi,
    I have table as attached. Depending on the value for CSSExch and ShortQ, the corresponding entry is selected.

    Is there any logic to get the same in oracle. kindly help
     

    Attached Files:

  2. vibhasss

    vibhasss Active Member

    Messages:
    7
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    India
    Hi,
    We can get this type of grouped data in Oracle using some complex queries, but please tell what exactly is the requirement.
    How is date stored, is grouping done, or we should do it.. etc..