title: how to debug SQL(oracle) query logic
body: <p>I have written the SQL queries using inner join with two tables. Syntax is right and but when I am executing the it is NOT producing desired output.</p>
  
  <p>How to debug the logical part of it in SQL. If it is PL/SQL we can either use DBMS_OUPUT.put_line() or use single step debugger to find out the logic working or not.<br>
  How to do thee similar one in SQL.</p>
  
  <p>Appreciate your answers.</p>