Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Odd sysdate construction

Re: Odd sysdate construction

From: Vladimir Begun <Vladimir.Begun_at_oracle.com>
Date: Wed, 12 Jan 2005 10:28:17 -0800
Message-ID: <41E56C41.1080504@oracle.com>


Freeman, Donald wrote:
> select SYSDATE@! from dual;
> This appeared in a client query (actually it was trunc(sysdate@!) )
> What is the @!? Its valid in the Oracle takes it but I can't find any =
> documentation as to what it is. It seems to act the same as plain old =
> sysdate. But it's the only place where @! Is allowed.

Please review:
http://www.orafaq.net/maillist/oracle-l/2003/10/17/1450.htm

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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 12 2005 - 12:30:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US