In Oracle Database, the JSON_OBJECTAGG() function creates a JSON object from a key-value pair.
Typically, the property key, the property value, or both are columns of SQL expressions.
Continue readingTag: what is
JSON_OBJECT() Function in Oracle
In Oracle Database, the JSON_OBJECT() function creates a JSON object from a sequence of key-value pairs or one object type instance.
JSON_ARRAYAGG() Function in Oracle
In Oracle Database, the JSON_ARRAYAGG() function creates a JSON array from a column of SQL expressions.
JSON_ARRAY() Function in Oracle
In Oracle Database, the JSON_ARRAY() function creates a JSON array from a sequence of SQL scalar expressions or one collection type instance, VARRAY or NESTED TABLE.
JSON_TABLE() Function in Oracle
In Oracle Database, the JSON_TABLE() function creates a relational view of JSON data. It allows you to present the values in a JSON document in table format – as rows and columns.
JSON_VALUE() Function in Oracle
In Oracle Database, the JSON_VALUE() function finds a specified scalar JSON value in JSON data and returns it as a SQL value.
JSON_QUERY() Function in Oracle
In Oracle Database, the JSON_QUERY() function selects and returns one or more values from JSON data and returns those values.
You can use the function to retrieve fragments of a JSON document.
Continue readingUID – Return the ID of the Current Session in Oracle
In Oracle Database, the UID function returns an integer that uniquely identifies the session user (the user who logged on).
USER Function in Oracle
In Oracle Database, the USER function returns the name of the session user (the user who logged on).
SYS_GUID() Function in Oracle
In Oracle Database, the SYS_GUID() function generates and returns a globally unique identifier (RAW value) made up of 16 bytes.
On most platforms, the generated identifier consists of a host identifier, a process or thread identifier of the process or thread invoking the function, and a nonrepeating value (sequence of bytes) for that process or thread.
Continue reading