title: DOS BAT Command: Verifying SQL PLUS SQL Query
body: <p>I had created the following command in my .bat file:</p>
  
  <pre><code>@echo select count(*) from table where column1 = 'abc'; | sqlplus username/password@database
  </code></pre>
  
  <p>Depending on the result returned, I need it different SQLs. How can I do it?</p>
  
  <p>e.g. if the resultset returned is 0, I need it to exit the .bat file. If the resultset is not 0 (1 or >1), then I will execute another SQL statement.</p>
  
  <p>Please help.</p>