OraFAQ Forum: SQL & PL/SQL » How to generate JSON

Home » SQL & PL/SQL » SQL & PL/SQL » How to generate JSON (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to generate JSON [message #663829]

Wed, 21 June 2017 03:38

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi All,

I've Oracle 12.1.0.2.0
I want to generate JSON. Can you please help me or point to me on any tutorial. Whatever I found on google is valid for release 2. I also didn't find APEX_JSON package.

https://docs.oracle.com/database/122/ADJSN/generation.htm#ADJSN-GUID-C0F8F837-EE36-4EDD-9261-6E8A9245906C

Please help me.

Thanks & Regards
Manoj

Report message to a moderator

Re: How to generate JSON [message #663831 is a reply to message #663829]

Wed, 21 June 2017 03:42

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

What version of APEX have you installed? You get APEX_JSON and the rest with release 5.1, I don't know about earlier releases.

Report message to a moderator

Re: How to generate JSON [message #663840 is a reply to message #663831]

Wed, 21 June 2017 05:00

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi John,

Thanks for the reply.

After reading you reply I guess I'm confused in two things.

I want to generate JSON from oracle database procedure and store output in a table.

How to achieve this?

I found below functions which can be used to generate JSON in Oracle 12c Release 2 but I'm working on 12.1.0.2.0

JSON_OBJECT
JSON_ARRAY
JSON_OBJECTAGG
JSON_ARRAYAGG

Is there any option available in Oracle 12.1.0.2.0

Thanks & Regards
Manoj

Report message to a moderator