Re: [SQL] CURRENT_TIMESTAMP

SQL> create table rbr_foo (a date);

Table created.

SQL> begin
  2  insert into rbr_foo select sysdate from dual;
[...wait about 10 seconds...]
  3  insert into rbr_foo select sysdate from dual;
  4  end;
  5  /

PL/SQL procedure successfully completed.

SQL> select * from rbr_foo;

A
---------------------
SEP 27, 2002 12:57:27
SEP 27, 2002 12:57:27

Note that, as near as I can tell, Oracle 8 does NOT have timestamp or
current_timestamp.  Online docs say both are present in Oracle 9i.

roland
--
               PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
roland@astrofoto.org                       Forest Hills, NY 11375