Sometimes we want to send an email when something suspicious happens in a database. Oracle is able to natively send emails.
Tag: level-expert
SQL Server: Send alerts via email
Sometimes we want to send an email when something suspicious happens in a database. SQL Server is able to natively send emails.
Db2 triggers: FOR EACH ROW, FOR EACH STATEMENT, DB2ROW, DB2SQL
There is some confusion about the FOR EACH, the MODE, and the BEFORE / AFTER clauses of Db2 CREATE TRIGGER. While other clauses are common to most DBMSs, MODE is a Db2 unique feature. Their meaning is simpler than it seems.
MariaDB: Select the Fibonacci series
How to select the first N numbers from the Fibonacci series, or the Nth number from the series. This is done by using the SEQUENCE storage engine and user variables.