Skip to content

SQL Bits

You're here to find quick SQL recipes.

  • Home
  • Topics
    • Generic SQL
    • PostgreSQL
    • MariaDB
    • MySQL
    • Oracle
    • SQL Server
    • Db2
    • Informix
    • SQLite
  • Advertising
  • Write
  • About

Tag: level-expert

Oracle: Send alerts via email

Sometimes we want to send an email when something suspicious happens in a database. Oracle is able to natively send emails.

Continue reading Oracle: Send alerts via email
Published July 27, 2021
Categorized as Oracle Tagged 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.

Continue reading SQL Server: Send alerts via email
Published July 26, 2021
Categorized as SQL Server Tagged level-expert

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.

Continue reading Db2 triggers: FOR EACH ROW, FOR EACH STATEMENT, DB2ROW, DB2SQL
Published July 26, 2021
Categorized as Db2 Tagged level-expert

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.

Continue reading MariaDB: Select the Fibonacci series
Published July 22, 2021
Categorized as MariaDB Tagged level-expert

Posts navigation

Newer posts Page 1 Page 2
  • Twitter
  • Email
SQL Bits
Proudly sponsored by Vettabase.