Skip to content
Tagged articles

database programming

2 articles · Page 1 of 1

Wallet, Pre-Made Meals & Calculators: Master Database Triggers, Procedures & Functions

This article explains MySQL triggers, stored procedures, and user-defined functions using relatable analogies—a wallet for triggers, pre-made meals for procedures, and a custom calculator for functions—complete with syntax templates, practical code examples for automated data logging, batch revenue calculation, and tiered commission logic, plus a selection guide for choosing the right tool.

MySQLSQLautomated logging
0 likes · 11 min read
Wallet, Pre-Made Meals & Calculators: Master Database Triggers, Procedures & Functions
ITPUB
ITPUB
Jan 18, 2016 · Databases

Mastering Tic‑Tac‑Toe with Oracle SQL: Generate All Endgames & Find Forced Wins

This article presents two Oracle SQL challenges from the 3rd ITPUB "Shengtou Media Cup" Tic‑Tac‑Toe contest, detailing how to generate every possible terminal game sequence for insertion into a table and how to compute forced win strategies for any given board using pure SQL techniques.

AlgorithmOracleSQL
0 likes · 14 min read
Mastering Tic‑Tac‑Toe with Oracle SQL: Generate All Endgames & Find Forced Wins