title: Long dynamic Oracle query and How to debug it
body: <p>I have a stored procedure that, I am currently working on which uses dynamic sql query.</p>
  
  <p>It has one variable assigned to (5000 - 6000 characters of dynamic SQL) and another variable assigned to (5000 - 6000 characters of dynamic SQL)
  and a UNION ALL between both the variables.</p>
  
  <p>I got the dynamic query from the procedure and ran it on the editor. It returned me a row of data. How can I debug this query?</p>
  
  <p>Can I do:</p>
  
  <pre><code>var1 = "dyamic SQL..." 
  UNION ALL 
  var2 = "dynamic SQL..."
  </code></pre>
  
  <p>Any advice to help me debug this would be very much appreciated.</p>