title: Data masking in Oracle SQL select statement
body: <p>Without using PL/SQL, is it possible to do data masking in SELECT statement?</p>
  
  <p>For example:</p>
  
  <p><strong>(AS-IS)</strong> <code>SELECT 'this is a string' from DUAL;</code></p>
  
  <p>this is a string </p>
  
  <p>(<strong>TO-BE</strong>) <code>SELECT 'this is a string' from DUAL;</code></p>
  
  <p>xxxx xx x xxxxxx </p>