title: Oracle Missing Right Parenthesis
body: <p>Here is my query:</p>
  
  <pre><code>SELECT * FROM Auta WHERE SUBSTR(spz, 1, 2) = 
  (SELECT SUBSTR(spz, 1, 2) FROM Auta WHERE typ = 'BMW' AND specifikacia_typu = 'Z1' LIMIT 1);
  </code></pre>
  
  <p>And when I run it I get this error:</p>
  
  <pre><code>ORA-00907: missing right parenthesis
  </code></pre>
  
  <p>I'm getting a little desperate, I've already tried adding parentheses everywhere in the query and I still get the error? There are 3 left and 3 right parentheses in the query so everything should be all right.</p>