Why and how to write comments on database, tables, and other objects on most DBMSs. How to read comments.
Category: Oracle
Find Oracle version and edition
How to know Oracle edition and version number in use for this instance.
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.
Find the maximum text length in a column
How to get the length of the longest text in a column. Including Db2 specific syntax.
Create a cross-table unique ID
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.