Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Dynamic Json into a table format

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
Best Answer
-
It is not clear what is your question. You have json document of unknown structure. Parsing it out and getting tag names and their values isn't an issue. However, in general json maps into set of tables (e.g. customers, suppliers, products, orders... are all part of json document). And even if your json is simple enough to map into a single table how can you save it into relational table if you don't know json structure upfront? The only way I can see is having value pair table.
SY.
Answers
-
It is not clear what is your question. You have json document of unknown structure. Parsing it out and getting tag names and their values isn't an issue. However, in general json maps into set of tables (e.g. customers, suppliers, products, orders... are all part of json document). And even if your json is simple enough to map into a single table how can you save it into relational table if you don't know json structure upfront? The only way I can see is having value pair table.
SY.
-
Representing them in the form of a table is enough based on the provided json (Consider Simple json). I'm able to get the json into the clob collection. And also, able to figure out the tag names. But, i'm not able to represent the json clob collection in the form a table with the respective tag names.
Regards,
Ramesh G
-
hsemar wrote: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
You should be asking in the space, there’s built in functionality for what you seem to want to do. It will obviously be version dependent so don’t forget to include that (Hint: APEX 19 has a lot of extra functionality that you probably want)
-
@hsemar Did you do it finally? I have a similar requirement of parsing dynamic nested Json into Oracle table. Please write me if you have done it.