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.
Tag: functions
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 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.
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).
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 readingNULLIF() Function in Oracle
In Oracle Database, the NULLIF() function compares two expressions, and returns null if both expressions are equal. If they are not equal, then the function returns the first expression.
NVL2() Function in Oracle
In Oracle Database, the NVL2() function allows us to replace null values with another value.
It’s similar to the NVL() function, except that it accepts three arguments instead of two. This allows us to specify a different value to return in the event the first argument is not null.
NVL() Function in Oracle
In Oracle Database, the NVL() function allows us to replace null values with another value.