Database Management Systems
When you run a query against an Oracle database using SQLcl or SQL*Plus, the results are displayed according to the SQLFORMAT option. But within that, there are other things you can do to customise the format of the results.
One of the things you can do is specify a column separator for the output grid.
In MariaDB, JSON_VALID() is a built-in function that allows you to check whether or not a value is a valid JSON document.
You pass the value as an argument, and JSON_VALID() returns 1 if it’s a valid JSON document, and 0 if not.
In Oracle, the ACOS() function returns the arccosine (inverse cosine) of its argument.
In other words, it returns the value whose cosine is the argument.
In Oracle, the ABS() function returns the absolute value of its argument.
The absolute value is the non-negative value of a real number without regard to its sign. It describes the distance from zero that a number is on the number line, without considering direction.
In MariaDB, JSON_UNQUOTE() is a built-in function that removes quotes from a JSON value. In other words, it “unquotes” a JSON value.
In MariaDB, JSON_TYPE() is a built-in function that returns the type of a JSON value, as a string.
Here are seven ways to check which version of Oracle Database you’re running.
In MariaDB, JSON_SEARCH() is a built-in function that allows you to get the path to a given value in a JSON document.
It accepts the JSON document and a string as arguments, and returns the path to the given string within the document.
In MariaDB, JSON_REMOVE() is a built-in function that removes data from a JSON document and returns the result.
Here’s a quick and easy way to install Oracle Database on a Mac.
First up, Oracle isn’t available natively on the Mac. But don’t let that stop you!
If you’re a developer, and you just want to have Oracle Database running on your local machine, there are ways to do it. In fact, Oracle provides us with a virtual appliance precisely for that purpose.