Re[2]: What is difference between "SYSDATE" and "SYSDATE@!" ??

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 17 Oct 2003 17:24:24 -0800
Message-ID: <F001.005D3845.20031017172424@fatcity.com>

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

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 Oracle-article-request_at_gennick.com 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> SYSDATE@!
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, sysdate@! is a synonym for @#$%! Sysdate or f***ng sysdate. As
KW> such,
KW> sysdate@! 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 SYSDATE@! 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 "SYSDATE@!" ??
>>
>>
>>
>> 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: mgogala_at_adelphia.net

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: ListGuru_at_fatcity.com (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: jonathan_at_gennick.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 - 20:24:24 CDT