Re: How to delay the execution of an SQL statement?

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CD18E4E.35BE24BE_at_exesolutions.com...
> FC wrote:
>
> > "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> > news:3CD00A75.99B75BA1_at_exesolutions.com...
> > > Ed Prochak wrote:
> > >
> > > > I'm always curious about this is a database context: Why do you want
a
> > > > delay?
> > > > (I've done lots of real-time/embedded programming where this kind of
> > > > thing is sometimes appropriate, but I don't know of any database
reasons
> > > > for this.)
> > > >
> > > > ed
> > > >
> > > > Anirban wrote:
> > > > >
> > > > > I want to delay the execution of an SQL statement in a PL/SQL
block.
> > > > > Is there any function like 'wait' or 'delay' which will delay the
> > > > > query?
> > > >
> > > > --
> > > > Edward J. Prochak --- Magic Interface, Ltd.
> > > > Ofc: 440-498-3700
> > > > on the web at --- http://www.magicinterface.com
> > > > email: ed.prochak_at_magicinterface.com
> > >
> > > So that later on you can go back to the customer and charge thousands
of
> > > dollars to "tune" things and make them faster. (just kidding ... I
think)
> > >
> > > Daniel Morgan
> > >
> >
> > Well,
> > I have a similar question, I'd like to make a stored procedure enter
into a
> > "stand-by" state without consuming too much CPU time.
> > Say for instance I am looping waiting for a user triggered event, how
can I
> > doze for half a second and then wake up again ?
>
> What are you going to do if the triggering event never happens?
>
> Daniel Morgan
>

Well, this is required only for running a test and simulate some things going on in a production plant, in the "real" world, there won't be any trace of it...

Cheers,
Flavio Received on Fri May 03 2002 - 07:09:23 CDT