4 Replies Latest reply: Oct 17, 2013 2:32 PM by odie_63 RSS

    how to get multilvel data in oracle using xml??

    913349

      i have table  sample_date column like

      faciltiy_id, Company_name,employee_type,  visitor,      categories,   lead,   aid,  aprocessid

      1k              ignis                    permanet      Damby     cat1            Y       101     777

      2k              proliant                permanet       Dillip        cat2            N       101     777

      ..               .......                   

      ...

      ...

      Note :there is no constraint


      i am using oracle 11g and sql developer 3.2

      i need out put like this 

      {

      "facility_id": "1k",

      "Company_name": "ignis",

      "Employee_type": "Permanet",

      "multiinformation": [

      {

      "visitor": [

      "Damby",

      "Dillip",

      ],

      "categories": [

      "cat1",

      "cat2",

      ],

      "lead": [

      "Y",

      "N",

      ]

      }

      ],

      "aId": "101",

      "aProcessId": "777"

      }


      Please please  help me


      Thanks

      Damby