OK, I just received this answer from an Oracle 9 tester. It shows CURRENT_TIMESTAMP changing during the transaction. Thanks, Dan.
Dan, it wasn't clear if this was in a transaction or not. Does Oracle have autocommit off by default so you are always in a transaction? --------------------------------------------------------------------------- Dan Langille wrote: > A very quick answer: > > ------- Forwarded message follows ------- > Date: Mon, 30 Sep 2002 13:03:51 -0400 (EDT) > From: Agent Drek <[EMAIL PROTECTED]> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: Re: Any Oracle 9 users? A test please... > In-Reply-To: <3D984877.19685.801EEC30@localhost> > Message-ID: <Pine.BSF.4.44.0209301303030.50384- > [EMAIL PROTECTED]> > MIME-Version: 1.0 > Content-Type: TEXT/PLAIN; charset=US-ASCII > Sender: [EMAIL PROTECTED] > > On Mon, 30 Sep 2002, Dan Langille wrote: > > > Date: Mon, 30 Sep 2002 12:49:59 -0400 > > From: Dan Langille <[EMAIL PROTECTED]> > > Reply-To: "[EMAIL PROTECTED]" > > <[EMAIL PROTECTED]> To: "[EMAIL PROTECTED]" > > <[EMAIL PROTECTED]> Cc: "[EMAIL PROTECTED]" > > <[EMAIL PROTECTED]> Subject: Any Oracle 9 users? A test > > please... > > > > Followups to [EMAIL PROTECTED] please! > > > > 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? > > > > Thanks > > > > Our DBA says: > > <snip from irc> > > <data> SQL> SELECT current_timestamp FROM DUAL; > <data> CURRENT_TIMESTAMP > <data> > ---------------------------------------------------------------------- > > ----- <data> 30-SEP-02 01.06.42.660969 PM -04:00 <data> SQL> SELECT > current_timestamp FROM DUAL; <data> CURRENT_TIMESTAMP <data> > ---------------------------------------------------------------------- > > ----- <data> 30-SEP-02 01.06.48.837372 PM -04:00 <data> (you have to > include 'from dual' for 'non-table' selects) > > -- > Derek Marshall > > Smash and Pow Inc > 'digital plumber' > http://www.smashpow.net > > > To Unsubscribe: send mail to [EMAIL PROTECTED] > with "unsubscribe freebsd-database" in the body of the message > > ------- End of forwarded message ------- > -- > Dan Langille > I'm looking for a computer job: > http://www.freebsddiary.org/dan_langille.php > > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
