Thursday, 24 January 2013

Generate XML/Json from database

To interact with external services XML or JSON format is necessary. It's not that hard to generate XML or JSON from the database.

Statement for xml
     SELECT dbms_xmlgen.getxml ('SELECT team,categorie from FWD_TEAMS) XML 
   FROM dual;


Statement for JSON (in apex in on-demand-process?)

     l_sql varchar2(200);
     l_sql := 'SELECT team,categorie from fwd_teams';

   ,{"TEAM":"M3F1","CATEGORIE":"Jongste Jeugd"}]}

In Apex of course you can define a region as a webservice. This webservice returns JSON or XML.


  1. Thanks for sharing your beautiful work and for the inspiration. I'm a huge fan and this one is my favorite to date. Love it!Hope to have more good articles.Oracle Training

  2. Hi! I am a digital marketer. The previous seo guy working for my client left a spammy comment at your blog with the username ascencion rana which links to my client's site.
    Such comments are or might cause serious damage to my client's site with respect to SEO which is why I am request you here by to remove it asap.
    If you don't remove it by 11:59 pm, Pacific Standard Time, 3rd January 2014, we will have use Google's Disavow Tool to get back-link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comment. Thanks in advance for your cooperation.