Fascinating. I've tried: SYSDATE@ no [EMAIL PROTECTED] no SYSDATE@@ no SYSDATE! no
and [EMAIL PROTECTED] yes But why? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. Friday, October 17, 2003, 8:44:24 PM, you wrote: KW> Actually it works also when there is space between sysdate and @!. SQL>> select sysdate @! from dual; KW> [EMAIL PROTECTED] KW> --------- KW> 17-OCT-03 KW> -----Original Message----- KW> Sent: Friday, October 17, 2003 8:14 PM KW> To: Multiple recipients of list ORACLE-L KW> Actually, [EMAIL PROTECTED] is a synonym for @#$%! Sysdate or f***ng sysdate. As KW> such, KW> [EMAIL PROTECTED] has its function and it fulfills it perfectly. KW> On 2003.10.17 14:41, "Mercadante, Thomas F" wrote: >> Uh..... I think that SYSDATE works, while [EMAIL PROTECTED] does not. >> >> >> Tom Mercadante >> Oracle Certified Professional >> >> -----Original Message----- >> Sent: Thursday, October 16, 2003 12:20 PM >> To: Multiple recipients of list ORACLE-L >> >> >> HI ALL >> >> What is difference between "SYSDATE" and "[EMAIL PROTECTED]" ?? >> >> >> >> Waleed Haggagy >> >> >> KW> -- KW> Mladen Gogala KW> Oracle DBA KW> -- KW> Please see the official ORACLE-L FAQ: http://www.orafaq.net KW> -- KW> Author: Mladen Gogala KW> INET: [EMAIL PROTECTED] KW> Fat City Network Services -- 858-538-5051 http://www.fatcity.com KW> San Diego, California -- Mailing list and web hosting services KW> --------------------------------------------------------------------- KW> To REMOVE yourself from this mailing list, send an E-Mail message KW> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in KW> the message BODY, include a line containing: UNSUB ORACLE-L KW> (or the name of mailing list you want to be removed from). You may KW> also send the HELP command for other information (like subscribing). KW> -- KW> Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
