Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic Json into a table format

hsemarJun 10 2019 — edited Jun 14 2019

Hi,

I have  working on some dynamic representation of json (Generated by a rest webservice call) in the form of a table [In oracle apex to represent in the form a table].  My Webservice call return dynamic column names, how to represent in the form of a table through SQL or PLSQL.  Is this possible.

All examples are shown if we know the key values in the json.   But i'm not aware of those keys, what ever keys that generated by webservice call, those should be my column names.

e.g.,

If My webservice call generates 

{

name:  "ramesh"

age:  30

}

Some times, the webservice call might generate more columns or a different column names.

{

name" "ramesh"

dept : "ECE"

title: "Sr.

lastname: "gopi"

}

How do i represent this in the webservice call if i have a dynamic column names through apex_json.  I am trying to implement using apex_json but not successful.  Any suggestions..

Regards,

Ramesh G

This post has been answered by Solomon Yakobson on Jun 10 2019
Jump to Answer

Comments

Post Details

Added on Jun 10 2019
4 comments
1,226 views