Using functions in WITH clause in Oracle 12c
The WITH Clause, or Subquery Refactoring If you haven’t heard of the WITH clause, let me take a moment to explain what it is. The WITH clause is a clause in SQL that allows you […]
Day: August 31, 2017
How to Replace Special Characters in Oracle SQL
Options for Replacing Special Characters In Oracle SQL, you have three options for replacing special characters: Using the REPLACE function Using the REGEXP_REPLACE function Using the TRANSLATE function Each of them has their pros and […]
