Horton

Re: (Fwd) Re: Any Oracle 9 users? A test please...

Mike Mascari <mascarm@mascari.com>

View thread View on postgr.es
From: Mike Mascari <mascarm@mascari.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Yury Bokhoncovich <byg@center-f1.ru>, Dan Langille <dan@langille.org>, Roland Roberts <roland@astrofoto.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-10-02T15:29:29Z
Lists: pgsql-hackers 
Bruce Momjian wrote:
> Mike Mascari wrote:
 >>
>>Oracle isn't processing those statements interactively. SQL*Plus 
>>is waiting on the "/" to send the PL/SQL block to the database. 
>>I suspect its not going to take Oracle more than a second to 
>>insert a row...
> 
> 
> Oh, I understand now.  He delayed when entering the function body, but
> that has no effect when he sends it.  Can someone add an explicit sleep
> in the function body and try that?
> 

SQL> create table foo (a date);

Table created.

SQL> begin
   2  insert into foo select sysdate from dual;
   3  dbms_lock.sleep(5);
   4  insert into foo select sysdate from dual;
   5  end;
   6  /

PL/SQL procedure successfully completed.

SQL> select to_char(a, 'HH24:MI:SS') from foo;

TO_CHAR(
--------
11:31:02
11:31:07

Mike Mascari
mascarm@mascari.com