Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to make the SQL to run longer?
On Jun 27, 3:30 pm, Raj <jkama..._at_gmail.com> wrote:
> Hell All,
> To reproduce one of our cusotmer's probem, I need to make the SQL to
> run for more than a minutes before it returns the result set. I do
> not
> have large amount of data in the database to simulate the dealy.
>
> Is there a way in SQL to cause the delay while returning the result
> set
>
> Thanks for the help.
> Regards
> Raj
How about defining a function that takes 60 seconds to return.
select my_function() from dual;
Containing a loop like this one
BEGIN
DECLARE
moment DATE;
BEGIN
moment := SYSDATE;
LOOP
EXIT WHEN SYSDATE - moment >= 1/24/60;
END LOOP;
END;
END;
/
Received on Wed Jun 27 2007 - 16:00:13 CDT