<div>
In short:<br />
Create a table with a CLOB and store the JSON there.<br />
<br />
Depending on what you want to do with it once it is stored, starting in 12.1 there is a JSON data type:<br />
<a href="https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6246" rel="ugc">https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6246</a><br />
<br />
That should provide a few more options if you want to access the data itself.<br />
<br />
<br />
Can you provide more information? &nbsp;Like pretty much everything you are wanting to do.<br />
<br />
Do you want to do this with middleware/code?<br />
Do you want to do this from inside the database?<br />
How do you want the JSON stored?<br />
Versions of database (all 4 numbers please, 11g/12c isn't enough)?<br />
etc...<br />
<br />
Sample data and expected results always help.
</div>


In short:
Create a table with a CLOB and store the JSON there.

Depending on what you want to do with it once it is stored, starting in 12.1 there is a JSON data type:
https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6246 [https://docs.oracle.com/database/121/ADXDB/json.htm#ADXDB6246]

That should provide a few more options if you want to access the data itself.


Can you provide more information?  Like pretty much everything you are wanting to do.

Do you want to do this with middleware/code?
Do you want to do this from inside the database?
How do you want the JSON stored?
Versions of database (all 4 numbers please, 11g/12c isn't enough)?
etc...

Sample data and expected results always help.

<div>
Thanks for the endorsement but don't forget to close the question.<br />
<br />
<a href="http://support.experts-exchange.com/customer/portal/articles/2527982" rel="ugc nofollow">http://support.experts-exchange.com/customer/portal/articles/2527982</a>
</div>


Thanks for the endorsement but don't forget to close the question.

http://support.experts-exchange.com/customer/portal/articles/2527982 [http://support.experts-exchange.com/customer/portal/articles/2527982]

<div>
<div class="content wysiwyg-content">
how can read data json from &nbsp;Url web service To oracle DataBase
</div>
</div>


how can read data json from  Url web service To oracle DataBase

how to get json data to database oracle

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

JavaScript Object Notation, or JSON, is human-readable text used when transmitting data objects consisting of attribute:value pairs between a server and a web application as an alternative to XML. JSON, while it is originally derived from JavaScript, is a language-independent data format. Code for parsing and generating JSON data is available in many programming languages.