SQL 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.
DBMS
Database Management Systems
How to Install SQLcl on a Mac
SQLcl 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.
Fix ‘The application “SQLDeveloper.app” can’t be opened.’
If 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.
MariaDB JSON_QUOTE() Explained
In MariaDB, JSON_QUOTE() is a built-in function that produces a valid JSON string literal that can be included in a JSON document.
It wraps the string with double quote characters and escapes interior quotes and other special characters, returning a utf8mb4 string.
MariaDB JSON_LOOSE() Explained
In MariaDB, JSON_LOOSE() is a built-in function that adds spaces to a JSON document to make it more readable.
It’s similar to the JSON_DETAILED() function, except that it doesn’t emphasise nested structures in the way that JSON_DETAILED() does.
For the opposite effect (i.e. to remove unnecessary spaces), use the JSON_COMPACT() function.
How to do a DELETE Pass-Through Query in SQL Server
In SQL Server, the OPENQUERY rowset function enables you to execute a pass-through query on a linked server.
OPENQUERY is commonly referenced in the FROM clause of a query as if it were a table, but it can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement.
This article presents an example of using OPENQUERY to do an DELETE pass-through query.
MariaDB JSON_LENGTH() Explained
In MariaDB, JSON_LENGTH() is a built-in function that returns the length of a JSON document.
When you call this function, you provide the JSON document as an argument. You can also provide a path argument to return the length of a value within the document.
MariaDB JSON_KEYS() Explained
In MariaDB, JSON_KEYS() is a built-in function that returns an array of the top-level keys from a JSON document. If a path is provided, it returns the top-level keys from that path.
It excludes keys from nested sub-objects in the specified level.
Also, if the selected object is empty, an empty array is returned.
MariaDB JSON_SET() Explained
In MariaDB, JSON_SET() is a built-in function that updates or inserts data into a JSON document and returns the result.
JSON_SET() can update and insert data, whereas JSON_INSERT() can only insert data, and JSON_REPLACE() can only update data.
MariaDB JSON_REPLACE() Explained
In MariaDB, JSON_REPLACE() is a built-in function that replaces existing values in a JSON document and returns the result.