PL/JSON
A PL/SQL object type and API for parsing, generating, and manipulating JSON data within Oracle databases.
What is PL/JSON?
PL/JSON is a PL/SQL library that provides object types and APIs for working with JSON data inside Oracle databases. It allows developers to parse, create, query, and manipulate JSON documents directly within PL/SQL code, enabling seamless integration of JSON with traditional relational data.
Oracle database developers and PL/SQL programmers who need to store, process, or expose JSON data within their database applications.
It offers a native, performant, and type-safe way to handle JSON in PL/SQL, with features like path querying and SQL-to-JSON conversion that simplify working with semi-structured data without leaving the database layer.
Overview
PL/JSON is a generic JSON object written in PL/SQL. Using PL/SQL object syntax, users instantiate a JSON object and then add members, arrays and additional JSON objects. This object type can store JSON data, in Oracle, persistently.
Use Cases
Best For
- Parsing and validating JSON documents stored in Oracle database columns
Related Projects
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
