delay — sleep for n seconds
delay
(
|
in
n_seconds
integer
); |
This will halt calling procedure execution for specified interval in seconds.
INTEGER number of seconds to sleep.
None
Example 24.89. Simple example
create procedure
waitsome (in _interval integer)
{
delay (_interval);
}
SQL> waitsome (10);
Done. -- 10004 msec.
© OpenLink Software 2016 .
This HTML5 document contains 16 embedded RDF statements represented using HTML+Microdata notation.
The embedded RDF content will be recognized by any processor of HTML5 Microdata.
| Prefix | IRI |
|---|---|
| schema | http://schema.org/ |
| n5 | http://creativecommons.org/licenses/by/4.0/ |
| rdf | http://www.w3.org/1999/02/22-rdf-syntax-ns# |
| n4 | http://www.openlinksw.com/# |
| xsdh | http://www.w3.org/2001/XMLSchema# |
| n2 | http://docs.openlinksw.com/virtuoso/fn_delay/ |
This HTML document contains 16 embedded RDF statements represented using (X)HTML+RDFa notation.
The embedded RDF content will be recognized by any processor of (X)HTML+RDFa.
| Prefix | URI |
|---|---|
| xmlns:schema | http://schema.org/ |
| xmlns:n5 | http://creativecommons.org/licenses/by/4.0/ |
| xmlns:rdf | http://www.w3.org/1999/02/22-rdf-syntax-ns# |
| xmlns:n4 | http://www.openlinksw.com/# |
| xmlns:xsdh | http://www.w3.org/2001/XMLSchema# |
| xmlns:n2 | http://docs.openlinksw.com/virtuoso/fn_delay/ |
| Subject | Predicate | Object |
|---|---|---|
| n2: | rdf:type | schema:TechArticle |
| n2: | rdf:type | schema:APIReference |
| n2: | schema:name | delay |
| n2: | schema:copyrightHolder | _:vb79276 |
| n2: | schema:datePublished | 2016-09-09 16:16:54 |
| n2: | schema:headline | delay |
| n2: | schema:keywords | OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data,function,API,reference,delay |
| n2: | schema:license | n5:deed.en_US |
| n2: | schema:publisher | _:vb79275 |
| n2: | schema:url | n2: |
| _:vb79275 | rdf:type | schema:Organization |
| _:vb79275 | schema:name | OpenLink Software |
| _:vb79275 | schema:url | n4:this |
| _:vb79276 | rdf:type | schema:Organization |
| _:vb79276 | schema:name | OpenLink Software |
| _:vb79276 | schema:url | n4:this |