SQL | A miscellaneous collection of useful Oracle SQL functions.
SQL
Tip 059: Table Locks
SQL | Understanding table locks and setting an exclusive lock
Tip 056: Data Scrambling
SQL | 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