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 […]
Oracle SQL
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 […]
Return multiple value from a function in oracle plsql
Normally when we came across the difference between function and procedure, we say that function always returns value(e.g single) where as procedure may or may not. But we can use OUT parameter to return multiple […]
How to handle a single quote in Oracle SQL
Problem: I have a column containing certain expressions stored as a text string which include single quotations, such as ‘missed transaction’ (INCLUDING the quotations) How can I use a where clause with such an occurrence? […]
