Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to make the SQL to run longer?

Re: How to make the SQL to run longer?

From: Chris L. <diversos_at_uol.com.ar>
Date: Wed, 27 Jun 2007 21:00:13 -0000
Message-ID: <1182978013.222657.122650@g4g2000hsf.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US