title: Generating json data file from oracle 10g database using sql
body: <p>I want to know how can I create a JSON API through which I can get Oracle 10g data using SQL in JSON format. </p>
  
  <p>I know that JSON_Object are introduced in Oracle 12C R2 but I have Oracle 10g and I want to get data from my Oracle 10g database in JSON format. </p>