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

"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 ? Received on Thu May 02 2002 - 07:08:40 CDT