Generating JSON with PL/SQL and APEX_JSON
Carsten Czarski wrote an excellent post on how to use the APEX_JSON package included in APEX 5, to generate JSON from table data. The post can be viewed in English by clicking the Show posts in english link at the top.