Create JSON string using standard functions using PL/SQL Oracle

Question

I am using Oracle database ver 12.1.0.2. I need to create JSON string using standard PL/SQL functions. Without using 3rd party libraries. For an example,

declare
   json_text varchar2(20);
begin
   json_text.add_as_json("key","value");
end;

Thank you!

Erich Kitzmueller · Accepted Answer · 2015-02-12 09:26:49Z

3

You could do it like that:

declare
   json_text varchar2(20);
begin
   json_text := '{"key":"value"}';
end;

but that obviously gets tedious in real-world cases. Better use a lib for that, for example this one: http://sourceforge.net/projects/pljson/

answered Feb 12, 2015 at 9:26

Erich Kitzmueller

37.1k5 gold badges85 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jon Heller Over a year ago

Surprisingly this seems to be as good as it gets. There are several Oracle methods for reading JSON but there doesn't appear to be anything for writing JSON.

Collectives™ on Stack Overflow

Create JSON string using standard functions using PL/SQL Oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related