title: ORA-00936: missing expression oracle
body: <p>I have this query</p>
  
  <pre><code>SELECT DAL_ROWNOTABLE.DAL_ID FROM 
  (
      SELECT ticket.id AS "DAL_ID",  ROWNUMBER ( Order By ticket.id  )  AS "DAL_ROWNUMBER" 
      FROM ticket_table ticket 
      WHERE ( ticket.type = N'I' ) 
      AND 
      ( 
          ticket.tenant IS NULL OR ticket.tenant IN 
          (
              SELECT  * FROM 
              ( 
                  SELECT tenant_group_member.tenant_id 
                  FROM tenant_group_member 
                  WHERE tenant_group_member.tenant_group = HEXTORAW('30B0716FEB5F4E4BB82A7B7AA3A1A42C') 
                  ORDER BY ticket.id 
              ) 
           ) 
       )
  ) DAL_ROWNOTABLE 
  WHERE DAL_ROWNOTABLE.DAL_ROWNUMBER BETWEEN 1 AND 21
  </code></pre>
  
  <p>What is the problem with the allow query that is throwing ORA-00936 missing expression? anyone? Any help will be appreciated...Error thrown at column:80 which is at the beginning of first order by:</p>