Re: Cancelling a long running query

From: Noel <tbal_at_go2.pll-l>
Date: Fri, 04 Nov 2005 17:10:46 +0100
Message-ID: <dkg1cl$b5q$2@inews.gazeta.pl>

User amogh wrote:

> Peter Kallweit wrote:

>> just try the following:
>>
>> create or replace function foo return number as
>> begin loop null; end loop; return 1; end;
>>
>> select foo from dual;

> Thanks! that was simple and useful!
>

But don't use it under Linux, they say, Linux can finish this endless loop in less than 20 seconds ;)

-- 
Noel

Received on Fri Nov 04 2005 - 10:10:46 CST