Re: Odd sysdate construction

  • From: Vladimir Begun <Vladimir.Begun@xxxxxxxxxx>
  • To: dofreeman@xxxxxxxxxxx, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 12 Jan 2005 10:28:17 -0800

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.

--
//www.freelists.org/webpage/oracle-l

Other related posts: