Why and how to write comments on database, tables, and other objects on most DBMSs. How to read comments.
How to know Oracle edition and version number in use for this instance.
Sometimes we want to send an email when something suspicious happens in a database. Oracle is able to natively send emails.
How to get the length of the longest text in a column. Including Db2 specific syntax.
Most tables are created with a unique, progressive ID. But how to create an ID whose values are unique across multiple tables? For example, if value 1 is in table A, it must not be in table B.