Re: Cancelling a long running query

Hi,

amogh wrote:
> Can someone please suggest me how I could write a query which executes
> continously (or recursively, to never return), using a table like EMP
> (or EMP joined with DEPT if necessary).
>

just try the following:

create or replace function foo return number as begin loop null; end loop; return 1; end;

select foo from dual;

hth
Peter Received on Wed Nov 02 2005 - 07:41:43 CST