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: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache inside. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
