In Oracle Database, the JSON_ARRAYAGG() function creates a JSON array from a column of SQL expressions.
Oracle
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.
How to Export Query Results to a CSV File in SQL Developer (Oracle)
You can do this to export your query results to a CSV file when using SQL Developer to query Oracle Database.
Return the Short Month Name from a Date in Oracle
In Oracle Database, we can use the TO_CHAR(datetime) function to return the various date parts from a datetime value, including the short month name.
The short month name is also referred to as the abbreviated month name. Examples of returning the short month name are below.
UID – 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).
How to Export Query Results to a CSV File in SQLcl (Oracle)
If you’re using SQLcl to run queries against Oracle Database, then you can use the SPOOL command to export your query results to a CSV file.
USER Function in Oracle
In Oracle Database, the USER function returns the name of the session user (the user who logged on).