When using SQLcl (Oracle’s command line interface), you can create a login.sql file, and have it run each time you run SQLcl.
This allows you to have commands executed each time you run SQLcl. For example, you can specify your formatting preferences in the login.sql file, set up aliases, etc.
Here I show you how to create a login.sql file and how to make it run each time you run SQLcl.
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.
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 readingIf you connect to MariaDB using the command line interface, you might sometimes find that your query results are too wide, due to the number of columns being returned, and the data they contain.
Continue readingAs of mongoimport version 100.0.0, you can delete documents in MongoDB based on an imported file. To do this, use delete mode.
When you use delete mode, if an imported document has the same _id value as an existing one in the collection that you’re importing into, the existing document will be deleted.
You can also specify another field or fields (other than the _id field) to be the matching field if required.
When using mongoimport, you can use the --jsonArray parameter to import an array of JSON documents.
When you use mongoexport to export documents in MongoDB, you have the option of “prettifying” them.
By this I mean, instead of the document being presented on one long line, it instead includes line breaks, indents, etc to make it easier to read.
To do this in mongoexport, use the --pretty parameter.
Here’s how to find out what version of psql you’re using.
Continue reading