Oracle JSON Functions

Oracle JSON Functions is a SQL function in the Oracle Specific category. Oracle 12c+: JSON functions for querying and generating JSON data. Supports path expressions and type checking. It accepts see syntax. It returns jSON query result. A close relative is SEQUENCE (Oracle), which oracle: generates sequential numbers. Independent of tables. Accessed via NEXTVAL and CURRVAL. A close relative is ROWNUM / FETCH FIRST, which oracle: ROWNUM assigns sequential numbers to rows. Used for limiting results (pre-12c). A close relative is SYSDATE / CURRENT_DATE, which oracle: returns the current date and time of the database server. More about this category: Oracle-specific features — SEQUENCE, ROWNUM, SYSDATE, CONNECT BY, PL/SQL. Related Oracle Specific entries: SEQUENCE (Oracle), ROWNUM / FETCH FIRST, SYSDATE / CURRENT_DATE, CONNECT BY (Hierarchical), DUAL Table, MERGE INTO (Oracle), FLASHBACK QUERY, WITH FUNCTION (Oracle 12c+). This page is part of the free SQL Reference documentation covering 762+ statements, functions, and clauses, each with syntax, parameters, return values, and examples for MySQL, PostgreSQL, SQL Server, and SQLite.