When using SQLcl to run queries against Oracle Database, you can specify the output of the query results using the following two options:
- The
SET SQLFORMATcommand - Add a comment shortcut to your query
Tag: how to
7 Options for Enabling Pipes (||) as the Concatenation Operator in MariaDB
By default, two pipe characters (||) are treated as a logical OR operator in MariaDB. However, you can change this behaviour if you like.
You can update your sql_mode to include the PIPES_AS_CONCAT option, in which case two pipes will be treated as a concatenation operator.
There are quite a few ways to add this option to your sql_mode. You can add it explicitly. Or you can set your sql_mode to an option that sets it implicitly.
I run through these options below.
Continue readingHow to Extract the Day, Month, and Year from a Date in SQLite
In SQLite, we can use the strftime() function to return datetime values in our chosen format.
Therefore, we can use it to extract the day, month, and year from a date.
Continue readingHow to Format Numbers with a Minus/Plus Sign in Oracle
When using the TO_CHAR() function to format a number in Oracle Database, you can use the S format element to return its sign (i.e. a plus sign for positive values, and a minus sign for negative values).
You can also use the MI format element to return negative values with a trailing negative sign, and positive values with a trailing blank.
How to Enable the Pipe Concatenation Operator in MySQL
MySQL supports the use of the pipe concatenation operator (||) for concatenating its operands. However, you need to enable it first.
3 Functions that Get the Day, Month, and Year from a Date in PostgreSQL
PostgreSQL provides us with several ways to get the day, month, and year from a date.
Three functions that immediately come to mind are; DATE_PART(), EXTRACT(), and TO_CHAR().
Export Query Results to an XML File when using SQLcl (Oracle)
When using SQLcl with Oracle Database, you can export your query results to an XML file with the SPOOL command.
Return the Day, Month, and Year in MySQL
MySQL has a bunch of different functions that enable us to get various date parts – such as the day, month, and year – from a date.
Continue readingFormat a Number as Currency in MariaDB
Here’s an example of formatting a number as currency in MariaDB.
Continue readingHow to Format Numbers as Currency in MySQL
Some DBMSs provide us with the ability to format a number as a currency by providing a format specifier for the currency symbol. Providing such a format specifier allows the DBMS to return the appropriate currency symbol for the locale.
MySQL doesn’t have a currency format specifier, and so we need to do a bit of extra work if we want the currency symbol to be returned.
Continue reading