In SQL Server, you can use the ALTER LOGIN statement to change the default language for a specific login.
Doing this will ensure that whenever that login connects to SQL Server, all date/time formats and system messages are presented in the correct format and language.
Continue readingIn Oracle Database, you can use the TO_CHAR() function to convert a number to its hexadecimal equivalent. To do this, use the X format element.
When getting the day and/or month name from a date in Oracle, you may want to return it in uppercase, lowercase, or title case.
Fortunately, this is easy to do. The result reflects the capitalisation of your format model.
Continue readingWhen using SQLcl to query Oracle Database, you can use the SET SQLFORMAT command to determine the format of the results.
You can also use inline comments to specify the format from directly within your query.
Continue readingWhen using SQLcl with Oracle Database, you can use the SPOOL command to export your query results to a file with an .html extension, and you can set SQLFORMAT to html in order to output the actual query results in HTML format.
If you need to replace a substring with another string in MariaDB, here are two approaches that you can use.
Continue readingYou can do this to export your query results to a CSV file when using SQL Developer to query Oracle Database.
Continue readingIn Oracle Database, we can use the TO_CHAR(datetime) function to return the various date parts from a datetime value, including the short month name.
The short month name is also referred to as the abbreviated month name. Examples of returning the short month name are below.
Continue readingIn Oracle Database, the UID function returns an integer that uniquely identifies the session user (the user who logged on).
If you’re using SQLcl to run queries against Oracle Database, then you can use the SPOOL command to export your query results to a CSV file.