Understanding table locks and setting an exclusive lock
SQL
Tip 056: Data Scrambling
Using the SQL ‘Random’ function to scramble sensitive data
Tip 049: Finding the Portal Location
SQL | Finding out the portal location for a component or page
Tip 047: Regular Expressions in SQL
SQL | Using regular expressions to carry out pattern matching
Tip 044: SQL Decode and Case Statements
SQL | Using the ‘Decode’ and ‘Case’ statements in queries.
Tip 021: Comma Separated List of Fields in a Record
SQL | Creating a comma-separated list of all the fields in a record