4 Replies Latest reply: Jun 11, 2013 8:17 PM by rp0428 RSS

    Can't Export data if WHERE clause contains AND/OR

    will_sj_county
      I am able to export the results of a query if the WHERE clause only has one condition. But if there is and AND or an OR, you can right-click and choose Export Data, but nothing happens.

      For example, the following will Export just fine:

      SELECT * FROM DUAL
      WHERE ROWNUM = 1;

      But throw in an 'AND', and it won't Export:

      SELECT * FROM DUAL
      WHERE ROWNUM = 1 AND ROWNUM < 2;

      I am running Ver 1.5.3 and haven't applied any patches.