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 readingCategory: Oracle
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.
Continue readingReturn 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.
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).
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).
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 readingHow to Return Fractional Seconds from a Datetime Value in Oracle
When using Oracle Database, you can use the TO_CHAR(datetime) function to return various parts of a datetime value, including the fractional seconds.
To return the fractional seconds part from a datetime value, use the FF format element.
NULLIF() 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.