If you have a hidden index in MongoDB, you can use the unhideIndex() method or the collMod administration command to unhide it.
Tag: how to
8 Functions to Return the Day from a Date in MariaDB
MariaDB has quite a number of functions that return the day from a date. It all depends on how you want to do it, and what you mean by “day”.
MariaDB needs to know whether you want the day name, the day of the week number, the day of the month, day of year, etc.
Below are 8 functions that enable you to return the day from a date in MariaDB, in its various forms.
Continue readingSET NULL: Specify a String to Return Whenever a Null Value Occurs in SQLcl / SQL*Plus
SQLcl and SQL*Plus are command line interfaces for working with Oracle Database.
By default, they return an empty string whenever null occurs as a result of a SQL SELECT statement.
However, you can use SET NULL to specify a different string to be returned. Here I specified that the string null should be returned.
How to Configure Syntax Highlighting in SQLcl
Starting with SQLcl version 21.2, we can now configure SQLcl for syntax highlighting.
That means that the code you write in SQLcl can be color coded, based on the syntax highlighting rules you apply.
Continue readingHow to Create a login.sql File for SQLcl
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.
How to Add Vertical Borders to your SQL*Plus / SQLcl Output Grid
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 reading7 Ways to Check your Oracle Version
Here are seven ways to check which version of Oracle Database you’re running.
Continue readingHow to Install Oracle on a Mac
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 readingHow to Install SQL Developer on a Mac
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.
Continue readingHow 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.
Continue reading