SQL Language (MOSC)

MOSC Banner

convert data to json file

If we have a data set like this :

branchID : BID0

issuer_country : EG

issuer_governate : Port Said

issuer_type : B

issuer_name : Issuer

receiver_country : EG

receiver_governate : New Cairo, Cairo

issuer_type : B

receiver_name : Receiver

How can we generate it in Json format exactly like this :

{

 "documents": [

  {

   "issuer": {

    "address": {

     "branchID": "BID0",

     "country": "EG",

     "governate": " Port Said"

    },

    "type": "B",

    "name": "Issuer"

   },

   "receiver": {

    "address": {

     "country": "EG",

     "governate": " New Cairo, Cairo "

    },

    "type": "B",

    "name": "Receiver"

   }

  }

 ]

}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center