Here’s an example of returning rows that contain alphanumeric characters in SQLite.
Alphanumeric characters are alphabetic characters and numeric characters.
Continue readingAuthor: Ian
How to Return the Month and Day Names in a Different Language in MariaDB
In MariaDB, you can use the DATE_FORMAT() function to return the month name and day name from a date.
This function accepts an optional argument that let’s you specify the language that is used for the result.
Continue readingList All Triggers in Oracle Database
Oracle Database includes several views that contain information about triggers in the database. We can use these views to return a list of triggers.
Continue reading4 Ways to Find Rows that Contain Lowercase Letters in MariaDB
Here are four options for returning rows that contain lowercase characters in MariaDB.
Continue readingHow to Subtract Hours from a Datetime Value in MariaDB
Here are some options for subtracting one or more hours from a datetime value in MariaDB.
Continue readingReturn Rows that Contain Numeric Values in Oracle
The following examples return only those rows that have numeric values in a given column in Oracle Database.
These examples use the REGEXP_LIKE function to return values that match the specified pattern.
How to Get the Recovery Model of a Database in SQL Server using T-SQL
In SQL Server, a recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. Databases can use one of the following three recovery models: simple, full, and bulk-logged.
You can query the sys.databases catalog view to get a list of databases and their recovery models.
2 Ways to Check the Compatibility Level in Oracle (SQLcl & SQL*Plus)
Here are two ways you can use SQLcl or SQL*Plus to check your Oracle Database compatibility level.
Continue readingFix MySQL Warning 1287: ‘BINARY expr’ is deprecated and will be removed in a future release
If you get warning number 1287 that reads ‘BINARY expr’ is deprecated and will be removed in a future release. Please use CAST instead when running a query in MySQL, it’s because you’re using the BINARY operator.
The BINARY operator is deprecated as of MySQL 8.0.27.
To fix the issue, cast the value to binary using the CAST() function instead.
5 Ways to Return Rows that Contain Lowercase Letters in SQL Server
If you need to find rows that contain lowercase letters in SQL Server, you could try one of the following options.
Continue reading