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