Is it possible in SQL to specify a timeout which the query must return by with any data retrieved so far?
Basically, some command that could be used along the lines of:
select /*+ timeout 30*/ * from veryLargeTable
So that after 30 seconds the query would return with all the data retrieved so far. I am aware of the where statement "rownum<10000" that can be used to limit the number of rows in the reply, but wish to use the timeout in addition.
You can specify a limit on the session, but not an individual statement from what I know. In Visual Basic 6 I know that this can be done. I believe it is implemented by the client sending some kill signal to Oracle (equivalent of a cancel or Ctrl-C).