From owner-freebsd-database Mon Sep 30 9:51:30 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BCFD537B401; Mon, 30 Sep 2002 09:51:28 -0700 (PDT) Received: from bast.unixathome.org (bast.unixathome.org [216.187.105.150]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0E93D43E65; Mon, 30 Sep 2002 09:51:28 -0700 (PDT) (envelope-from dan@langille.org) Received: from wocker (wocker.unixathome.org [192.168.0.99]) by bast.unixathome.org (Postfix) with ESMTP id 4203E3F4B; Mon, 30 Sep 2002 12:51:27 -0400 (EDT) From: "Dan Langille" To: freebsd-database@freebsd.org Date: Mon, 30 Sep 2002 12:49:59 -0400 MIME-Version: 1.0 Subject: Any Oracle 9 users? A test please... Reply-To: freebsd-database@freebsd.org Cc: freebsd-chat@freebsd.org Message-ID: <3D984877.19685.801EEC30@localhost> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Followups to freebsd-database@freebsd.org 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 -- Dan Langille I'm looking for a computer job: http://www.freebsddiary.org/dan_langille.php To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Sep 30 10: 3:55 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1814F37B401; Mon, 30 Sep 2002 10:03:54 -0700 (PDT) Received: from mail.smashpow.com (mail.smashpow.net [216.235.9.194]) by mx1.FreeBSD.org (Postfix) with ESMTP id C4B7743E42; Mon, 30 Sep 2002 10:03:52 -0700 (PDT) (envelope-from drek@smashpow.net) Received: from mail.smashpow.net (mail.smashpow.net [216.235.9.194]) by mail.smashpow.com (Postfix) with ESMTP id 1E8CA46; Mon, 30 Sep 2002 13:03:51 -0400 (EDT) Date: Mon, 30 Sep 2002 13:03:51 -0400 (EDT) From: Agent Drek To: "freebsd-database@freebsd.org" Cc: "freebsd-chat@freebsd.org" Subject: Re: Any Oracle 9 users? A test please... In-Reply-To: <3D984877.19685.801EEC30@localhost> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Mon, 30 Sep 2002, Dan Langille wrote: > Date: Mon, 30 Sep 2002 12:49:59 -0400 > From: Dan Langille > Reply-To: "freebsd-database@freebsd.org" > To: "freebsd-database@freebsd.org" > Cc: "freebsd-chat@freebsd.org" > Subject: Any Oracle 9 users? A test please... > > Followups to freebsd-database@freebsd.org 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: SQL> SELECT current_timestamp FROM DUAL; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 30-SEP-02 01.06.42.660969 PM -04:00 SQL> SELECT current_timestamp FROM DUAL; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 30-SEP-02 01.06.48.837372 PM -04:00 (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 majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Oct 2 2:42:55 2002 Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8BFB737B401 for ; Wed, 2 Oct 2002 02:42:54 -0700 (PDT) Received: from mta201-rme.xtra.co.nz (mta201-rme.xtra.co.nz [210.86.15.144]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8683E43E42 for ; Wed, 2 Oct 2002 02:42:53 -0700 (PDT) (envelope-from kit@hypostasis.com) Received: from mta1-rme.xtra.co.nz ([210.86.15.143]) by mta201-rme.xtra.co.nz with ESMTP id <20021002094252.ULJG7085.mta201-rme.xtra.co.nz@mta1-rme.xtra.co.nz>; Wed, 2 Oct 2002 21:42:52 +1200 Received: from amethyst.hypostasis.com ([219.88.79.81]) by mta1-rme.xtra.co.nz with ESMTP id <20021002094251.XCJS16938.mta1-rme.xtra.co.nz@amethyst.hypostasis.com>; Wed, 2 Oct 2002 21:42:51 +1200 Received: from amethyst.hypostasis.com (localhost [127.0.0.1]) by amethyst.hypostasis.com (8.12.6/8.12.5) with ESMTP id g929jCLx036582; Wed, 2 Oct 2002 21:45:12 +1200 (NZST) (envelope-from kit@amethyst.hypostasis.com) Received: (from kit@localhost) by amethyst.hypostasis.com (8.12.6/8.12.6/Submit) id g929jCgv036581; Wed, 2 Oct 2002 21:45:12 +1200 (NZST) Date: Wed, 2 Oct 2002 21:45:12 +1200 From: kit To: freebsd-database@FreeBSD.ORG Cc: Dan Langille Subject: Re: Any Oracle 9 users? A test please... Message-ID: <20021002094512.GD36277@amethyst.hypostasis.com> References: <3D984877.19685.801EEC30@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3D984877.19685.801EEC30@localhost> User-Agent: Mutt/1.4i Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hi Dan Does this imply that you have 9 running on FreeBSD? I'm about to have a go at 8i but 9 would be nicer On Mon, Sep 30, 2002 at 12:49:59PM -0400, Dan Langille wrote: > Followups to freebsd-database@freebsd.org please! > > Any Oracle 9 users out there? --kit -- whois -h whois.gandi.net KM78-GANDI To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message