title: pass sqlplus value to shell variable
body: <p>the below picture shows what gets returned when I run sqlplus in shell</p>
  
  <p><img src="https://i.stack.imgur.com/wEdPw.png" alt="shell1"></p>
  
  <p>but when I run this from the "run" command:</p>
  
  <pre><code>powershell.exe -noexit c:\sqltriggers\voicetrigger2.ps1
  </code></pre>
  
  <p>with voicetrigger2.ps1 as this:</p>
  
  <pre><code>$(sqlplus user/pass@OMP1 '@C:\sqltriggers\VOICEBLOCKTRIG.SQL');
  </code></pre>
  
  <p>I get this:</p>
  
  <p><img src="https://i.stack.imgur.com/WVixM.png" alt="shell2"></p>
  
  <p>I should expect a 3 back. The issue is, I try to set that as a variable, and if the integer is greater than zero, run a BAT file. But I don't think the SQLPlus is returning JUST an integer value. I think its actually returning this:</p>
  
  <pre><code>count(*)
        3
  </code></pre>
  
  <p>How do I get it to just return the integer value from the SQLplus command?</p>