title: Can we execute SQL without having a real database connection in java?
body: <p>Can we execute SQL without having a real database connection in java?
  example:</p>
  
  <pre><code> SELECT CASE
            WHEN :param = 1 THEN 'TEST1'
            WHEN :param = 2 THEN 'TEST2'
            WHEN :param = 3 THEN 'TEST3'
         END
            AS RESULT
  FROM DUAL
  </code></pre>
  
  <p>I will replace :param in runtime in java code.
  Is there any way to do this?</p>
  
  <p>I found this link: <a href="https://stackoverflow.com/questions/14331263/how-do-i-extract-selected-columns-given-an-oracle-sql-string">How do I extract selected columns given an Oracle SQL String?</a></p>
  
  <p>but no quick solution is provided in this link</p>
  
  <p>Currently thinking of: dummy hsqldb connection and execute SQL query. But it requires to span a new in memory db.</p>
  
  <p>Is there any better &amp; quick solution?</p>