title: ORA-00907: missing right parenthesis in ORACLE SQL unexpected parenthesis issue
body: <p>I am trying to execute an SQL query to solve this problem:**Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.
  Sample Input:
  Let's say that CITY only has four entries:
  DEF, ABC, PQRS and WXY
  Sample Output:
  ABC 3
  PQRS 4</p>
  
  <p>**</p>
  
  <p>I was able to solve this challenge using MySQL.However I am facing error while trying to solve the same in Oracle ,albeit with minor changes.Here is what exactly I am trying with :</p>
  
  <pre><code>(SELECT CITY ,length(CITY)
  FROM STATION
  ORDER BY length(CITY) ASC ,CITY FETCH FIRST 1 ROW)
  UNION ALL
  (SELECT CITY ,length(CITY)
  FROM STATION
  ORDER BY length(CITY) DESC ,CITY FETCH FIRST 1 ROW); 
  </code></pre>
  
  <p>I get the error :</p>
  
  <pre><code>ORDER BY length(CITY) ASC ,CITY FETCH FIRST 1 ROW) 
  * 
  ERROR at line 3: 
  ORA-00907: missing right parenthesis 
  </code></pre>
  
  <p>I am unable to figure out the error here, given that I was able to solve it in an almost similar fashion in MySQL. Can someone please point out my mistake here?</p>