SQL | A miscellaneous collection of useful Oracle SQL functions.
SQL | Understanding table locks and setting an exclusive lock
SQL | Using the SQL ‘Random’ function to scramble sensitive data
SQL | Finding out the portal location for a component or page
SQL | Using regular expressions to carry out pattern matching
SQL | Using the ‘Decode’ and ‘Case’ statements in queries.
SQL | Creating a comma-separated list of all the fields in a record