Oracle-L: Re: What is difference between "SYSDATE" and "SYSDATE@!" ??

From: Vladimir Begun <vladimir.begun_at_oracle.com>
Date: Fri, 17 Oct 2003 18:24:24 -0800
Message-ID: <F001.005D3846.20031017182424@fatcity.com>

Jonathan

SYSDATE can be local and remote -- how to distinguish them?. Same is related to some other functions as well, e.g. USER. Try to do SELECT SYSDATE FROM sys.dual_at_link; and trace remote session. Oracle engine is smart enough.

Mladen, there is no "synonym for @#$%!", be more serious :)

-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

Jonathan Gennick wrote:


> Fascinating. I've tried:

> 

> SYSDATE@ no

> SYSDATE@# no

> SYSDATE@@ no

> SYSDATE! no

> 

> and SYSDATE@! yes

> 

> But why?

> 

> Best regards,

> 

> Jonathan Gennick --- Brighten the corner where you are

> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vladimir Begun
  INET: vladimir.begun_at_oracle.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Oct 17 2003 - 21:24:24 CDT