Home / Educational Content / Database & Technology / Real-Life JSON: From DIY to Oracle Datatype

Real-Life JSON: From DIY to Oracle Datatype

Quest Forum Digital Event 2020

The majority of modern IT solutions consist of multiple systems communicating using APIs. The “common language” is usually JSON. Unfortunately, the Oracle RDBMS did not have native JSON support until version 12c. Previously, developers had to use either third-party tools (the most popular was PL/JSON) or write their own code to support JSON processing. When it comes to database upgrades, the question arises: Should we utilize new features or not? This question is especially relevant when you need to edit 10,000+ lines of code and core system functionality.  The authors decided to accept a challenge and migrate from PL/JSON to Oracle native JSON and share their story with conference attendees.

Watch the full-length video

Premium Content: access is limited to Quest Corporate and Professional members.

Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.

Real-Life JSON: From DIY to Oracle Datatype