title: How to write in test case with in-memory-database?
body: <p>I am using Oracle as my database, Spring Boot as my framework.</p>
  
  <p>I don't know how to write a test case to check database query?
  I have heard that it is possible through In-Memory Database. But don't find a proper example.</p>
  
  <p>Suppose in my code I have written a SQL query that <code>SELECT * FROM tableName</code> and it is returning me a ResultSet Object.</p>
  
  <p>So in while writing test case how can I check that?</p>
  
  <p>Every time I don't want to go into the database and fetch a query.</p>
  
  <p>I know that is possible but my question is how can I replace my query's result with a dummy result which I will store in any file.</p>
  
  <p>Thanks in advance</p>