Re: Sleep or wait on Oracle SQL ?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 29 Mar 2001 10:33:56 +0200
Message-ID: <99us1k$v1f$1@s1.read.news.oleane.net>

"Kimbert Dy NIng" <bert_at_admicro.bc.ca> a écrit dans le message news: SzBw6.148340$tP3.2298518_at_news1.rdc1.bc.home.com...
> Is there a way to sleep() or wait for 'x' seconds within a loop in PL/SQL ?
>
> Thanks!
>
>

Dbms_lock.sleep (<nb seconds>);

--
Have a nice day
Michel

Received on Thu Mar 29 2001 - 02:33:56 CST

This message: [ Message body ]
Next message: David: "Commit -> write to data file immediately???"
Previous message: Kimbert Dy NIng: "Sleep or wait on Oracle SQL ?"
In reply to: Kimbert Dy NIng: "Sleep or wait on Oracle SQL ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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