Sometimes we want to send an email when something suspicious happens in a database. Oracle is able to natively send emails.
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
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.