Syntax options:

    LIMIT ROWS | NO LIMIT ROWS

    LIMIT ROWS sets the maximum number of rows that can be returned
    by a query started by the user. The keyword DEFAULT indicates
    that no value is defined by this profile and is equivalent to NO
    LIMIT ROWS.

    If a numeric value or the keyword UNLIMITED is specified then
    this value will be used even when the SET QUERY LIMIT ROWS
    statement is present in the session, or when the logical name
    RDMS$BIND_QG_REC_LIMIT is defined.

    NO LIMIT ROWS is the default.