1 Reply Latest reply on Feb 22, 2018 5:21 PM by Vadim Tropashko-Oracle

    Syntax error displayed when using fractional percentages in FETCH clause

    Lukas Eder

      The following statement generates a parser error in SQL Developer, even if it runs just fine:

       

      SELECT *

      FROM dual

      FETCH FIRST 1.5 PERCENT ROWS ONLY;

       

      Version 17.4.0.355

      Build 355.2349