Uh. I think that SYSDATE works, while [EMAIL PROTECTED] does
not.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Waleed Haggagy
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 12:20
PMTo: Multiple recipients of list ORACLE-LSubject: What
Actually, [EMAIL PROTECTED] is a synonym for @#$%! Sysdate or f***ng sysdate. As such,
[EMAIL PROTECTED] has its function and it fulfills it perfectly.
On 2003.10.17 14:41, Mercadante, Thomas F wrote:
Uh. I think that SYSDATE works, while [EMAIL PROTECTED] does not.
Tom Mercadante
Oracle
Actually it works also when there is space between sysdate and @!.
SQL select sysdate @! from dual;
[EMAIL PROTECTED]
-
17-OCT-03
-Original Message-
Sent: Friday, October 17, 2003 8:14 PM
To: Multiple recipients of list ORACLE-L
Actually, [EMAIL PROTECTED] is a
Jonathan
SYSDATE can be local and remote -- how to distinguish them?.
Same is related to some other functions as well, e.g. USER.
Try to do SELECT SYSDATE FROM [EMAIL PROTECTED]; and trace
remote session. Oracle engine is smart enough.
Mladen, there is no synonym for @#$%!, be more serious :)
--
Mladen, there is no synonym for @#$%!, be more serious :)
I promise! Scout's honor!
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Mladen Gogala wrote:
Mladen, there is no synonym for @#$%!, be more serious :)
I promise! Scout's honor!
I believe :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ:
