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

You’ve reached the ultimate Oracle customer network—exclusively for Quest Corporate and Professional members.

Join Quest to unlock access to strategic content centers, event replays, exclusive programming, and expert insights—all designed to help Oracle users like you go further, faster.

Whether you're on JD Edwards, PeopleSoft, or Oracle Cloud, Quest connects you with a powerful peer network and Oracle experts so you can make smarter decisions, drive innovation, and get more from your investment.

Quest is where Oracle customers connect, learn, and lead with confidence. Ready to join them?

Real-Life JSON: From DIY to Oracle Datatype