title: Set max rows to return using sqlplus
body: <p>I know I can add: <code>where rownum &lt;= 100</code> to each query but is there any global SET command in sqlplus that can limit the number of results returned by a query?</p>
  
  <p>ie <code>SET MAX_ROWS_TO_RETURN 100</code> so that it applies to all queries?</p>
  
  <p>The reason is because I have a bunch of sql files that I run using <code>@name.sql</code> and I don't want to have to alter each sql file individually.</p>