Hello!
On Mon, 30 Sep 2002, Bruce Momjian wrote:
> It is not clear to me; is this its own transaction or a function call?
BTW.
As reported by my friend:
Oracle 8.1.7 (ver.9 behaves the same way):
--- cut ---
SQL> SET TRANSACTION READ WRITE;
Transaction set.
SQL> SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY HH24:MI:SS') FROM DUAL;
TO_CHAR(SYSDATE,'MM
-------------------
02-10-2002 10:04:19
SQL> -- wait a lot
SQL> SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY HH24:MI:SS') FROM DUAL;
TO_CHAR(SYSDATE,'MM
-------------------
02-10-2002 10:04:27
SQL> COMMIT;
Commit complete.
--- cut ---
> > > > > Any Oracle 9 users out there?
> > > > >
> > > > > I need this run:
> > > > >
> > > > > BEGIN;
> > > > > SELECT CURRENT_TIMESTAMP;
> > > > > -- wait 5 seconds
> > > > > SELECT CURRENT_TIMESTAMP;
> > > > >
> > > > > Are those two timestamps the same?
--
WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group.
Phone: +7 (3832) 106228, ext.140, E-mail: byg@center-f1.ru.
Unix is like a wigwam -- no Gates, no Windows, and an Apache inside.