Re: Cancelling a long running query

From: amogh <amogh.r_at_gmail.com>
Date: Wed, 02 Nov 2005 20:16:34 +0530
Message-ID: <Ky4af.7$Y65.119@news.oracle.com>

Peter Kallweit wrote:
> 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

Thanks! that was simple and useful!

Rgds. Received on Wed Nov 02 2005 - 08:46:34 CST