Search

Top 60 Oracle Blogs

Recent comments

JSON

Oracle 12c: Indexing JSON In The Database Part I (Lazarus)

One of the very cool new features introduced in Oracle Database 12c Rel 1 is the ability to store JavaScript Object Notation (JSON) documents within the database. Unlike XML which has its own data type, JSON data can be stored as VARCHAR2, CLOB or BLOB data types, but with a JSON check constraint to ensure the […]

Playing around with JSON using the APEX_JSON package

hockey-149683_640We publish a number of XML web services from the database using the PL/SQL web toolkit, as described here. In more recent times we’ve had a number of requirements for JSON web services, so we did what most people probably do and Googled for “json pl/sql” and got a link to PL/JSON.

I know about the support for JSON in 12c, but we are not on 12c for these projects and that’s more about consuming JSON, rather than publishing it.

Going Full Circle – Building a native JSON Database API

Hereby a short post at the end of 2015 that has the presentation used during…

HOWTO: Building a JSON Database API (4)

While preparing the demo for my presentation tomorrow at the UKOUG Tech14 conference, I noticed…

Oracle 12.1.0.2.x – JSON Database Patch Bundle(s)

It has been a while I patched a local development database, but nowadays stuff gets…

JSON support in Exadata 12.1.2.1.0 and later

Some time ago Oracle announced that RDBMS 12.1.0.2 has built-in support for JSON processing. A little later it was also mentioned that you have support for JSON in the Exadata storage servers for offloading. This is probably a lot more exciting to users of JSON than it is to me as I’m not a developer. However, whenever an announcement such as the one I’m referring to is made I would like to see for myself how much of it is implemented in software. Like I said, I’m not a developer so apologies for a silly example: what I’m showing you here can probably done differently and is not the best use of an Exadata. But all I really wanted to test is if JSON support actually exists. I am using cellsrv 12.1.2.1.0 and RDBMS 12.1.0.2.2 for this test.

JSON

HOWTO: Building a JSON Database API (3)

Be aware (!), while following thru on the following, that there might be a change…

HOWTO: Building a JSON Database API (2)

After creating the initial structures to scrape some JSON content of Wikipedia, as mentioned in…