In Oracle Database, the JSON_OBJECT() function creates a JSON object from a sequence of key-value pairs or one object type instance.
Category: DBMS
Database Management Systems
Export Oracle Query Results to an HTML File when using SQLcl
When using SQLcl with Oracle Database, you can use the SPOOL command to export your query results to a file with an .html extension, and you can set SQLFORMAT to html in order to output the actual query results in HTML format.
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.Â
2 Ways to Replace a Substring in MariaDB
If you need to replace a substring with another string in MariaDB, here are two approaches that you can use.
Continue readingJSON_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 readingHow 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.
Continue readingDifference Between SYSDATE() and NOW() in MariaDB
In MariaDB, the SYSDATE() and NOW() functions are similar in that they return the current date and time.
However, there is an important difference: SYSDATE() returns the time that it executes, whereas NOW() returns the time that the statement started executing.
And when run within a stored procedure or trigger, SYSDATE() will return the time that it executes, whereas NOW() will return the time that the stored procedure or trigger started executing.