Return results of a sql query as JSON in oracle 12c

by

Oracle 12c version 12.1.0.2 (the latest version as of 11.11.2014) adds JSON support:
https://docs.oracle.com/database/121/NEWFT/chapter12102.htm#BGBGADCC

It’s been available since October 17th. https://blogs.oracle.com/db/entry/oracle_database_12c_release_1

If you are unable to patch/work with that version there is an excellent package written by Lewis Cunningham and Jonas Krogsboell: PL/JSON
* http://pljson.sourceforge.net/

It’s an excellent package (I have used it in numerous database installations).

The examples included are good and cover most scenarios. 

declare 
  ret json;
begin
  ret := json_dyn.executeObject('select * from tab');
  ret.print;
end;
/

More Related Contents:

  1. work with json in oracle
  2. Kotlin Json Parser
  3. Is there a streaming API for JSON? [closed]
  4. How to make HTTP Post request with JSON body in Swift
  5. Importing local json file using d3.json does not work
  6. Convert JSON format to CSV format for MS Excel [closed]
  7. JSON Invalid UTF-8 middle byte
  8. Nested ng-repeat
  9. How to import JSON File into a TypeScript file?
  10. Could not load file or assembly ‘Newtonsoft.Json’ or one of its dependencies. Manifest definition does not match the assembly reference
  11. Disable Hypertext Application Language (HAL) in JSON?
  12. how to parse a JSON String with jq (or other alternatives)?
  13. How to serialize or convert Swift objects to JSON?
  14. Spring Security and JSON Authentication
  15. How to parse JSON with VBA without external libraries?
  16. Cannot set content-type to ‘application/json’ in jQuery.ajax
  17. PowerShell : retrieve JSON object by field value
  18. Post a json body with swagger
  19. Convert a JSON array to a bash array of strings
  20. How to parse json and read in vb.net
  21. Spring REST service: retrieving JSON from Request
  22. iteration a json object on Ngfor in angular 2
  23. Angular2 Ansychronous bootstrapping with external json configuration file
  24. Only allow properties that are declared in JSON schema
  25. Split a JSON file into separate files
  26. Type ‘{}’ is not assignable to type ‘IntrinsicAttributes & IntrinsicClassAttributes
  27. Passing UTC DateTime to Web API HttpGet Method results in local time
  28. Register/login user with WordPress JSON API
  29. Post JSON to web in excel vba
  30. How to dynamically display a multiline text in D3.js?

Leave a Comment