SQL$HELP72.HLB  —  SET_QUERY, Examples
    Example 1: Shows the syntax for establishing a row limit within
    an interactive SQL session.

    SQL> set query limit rows 10000;
    SQL> show query limit;
    Query limit Time is OFF
    Query limit Row count is 10000 rows
    Query limit CPU time is OFF
    Execution limit CPU time is OFF
    Execution limit Elapsed time is OFF
    Execution limit Row count is OFF
    SQL> set query nolimit rows;
    SQL> show query limit;
    Query limit Time is OFF
    Query limit Row count is OFF
    Query limit CPU time is OFF
    Execution limit CPU time is OFF
    Execution limit Elapsed time is OFF
    Execution limit Row count is OFF

    Example 2: Uses SET QUERY to establish a two second elapsed time
    limit for a query, and shows the error message that is displayed.

    SQL> set query execution limit elapsed time 2 seconds;
    SQL> delete from EMPLOYEES;
    %RDB-E-EXQUOTA, Oracle Rdb runtime quota exceeded
    -RDMS-E-MAXTIMLIM, query governor maximum timeout has been reached
    SQL> set query execution nolimit elapsed time;
Close Help