Database Management Systems
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.
Continue readingIn 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.
Continue readingIn 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.
Continue readingIn 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.
Continue readingSQL Developer is a GUI tool for working with Oracle Database. It’s available on many major operating systems, including Window, Linux, and of course, MacOS.
Here’s a quick rundown on the steps I took to install SQL Developer on a Mac.
Continue readingSQLcl is a command line tool for working with Oracle Database. It’s available on many major operating systems, including MacOS.
Here’s a quick rundown on the steps I used to install SQLcl on a Mac.
Continue readingIf you just installed SQL Developer on a Mac, but you’re getting an error when trying to launch it, try the steps below to fix it.
The error reads “The application “SQLDeveloper.app” can’t be opened because Apple cannot check it for malicious software“. It also mentions that “This software needs to be updated. Contact the developer for more information“.
Below are the steps I used to overcome this issue, and launch SQL Developer.
Continue reading