Someone please do something about this... This stupid southampton address
keep coming to my mail box... I hope its happening the same with the other
listers....
Will anyone look at it and remove it?
Rajaram
(PS: the Failed message follows)
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 5:41 PM
To: [EMAIL PROTECTED]
Subject: Transient Delivery Failure
The attached message had transient non-fatal delivery errors
THIS IS A WARNING MESSAGE ONLY - YOU DO NOT NEED TO RESEND YOUR MESSAGE!
This server is configured to automatically retry delivery at configured
intervals. Subsequent attempts to deliver this message are pending.
--- Partial Session Transcript ---
Host [sccemail] resolved to [172.21.4.74]
Waiting for socket connection...
30 second wait for connect timeout exceeded.
This message is 61 minutes old; it has 0 minutes left in this queue
Primary queue lifetime exceeded; message placed in retry queue
--- End Transcript ---
: Message contains [1] file attachments
-----Original Message-----
From: Rajaram [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bad SQL.....
Remember - Drink responsibly - Kidding.
Raj.
-----Original Message-----
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Bad SQL.....
Thank you very much. I was thinking that I needed to do a nested select.
It worked great. I'll have a beer for you after I leave work! :)
Dave
-----Original Message-----
Sent: Friday, May 25, 2001 1:46 PM
To: Multiple recipients of list ORACLE-L
I think it's just Friday. You need to rewrite your statement to read
something like this:
UPDATE AVAILABLE_POWER SET available_power_driver_terminated = 'Y'
where available_power.driver_id in (select manpowerprofile.mpp_id
from manpowerprofile where manpowerprofile.mpp_terminationdt <>
to_date('31-DEC-2049','DD-MON-RRRR') )
At 09:01 AM 5/25/01 -0800, you wrote:
>I am trying to write an update statement but seem to be having problems.
>Below is my statement and the error in SQL*Plus.
>
>
> 1 UPDATE AVAILABLE_POWER SET available_power.driver_terminated = 'Y'
> 2 WHERE available_power.driver_id = manpowerprofile.mpp_id
> 3* and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-YYYY')
>SQL> /
> and manpowerprofile.mpp_terminationdt <>
>TO_DATE('31-DEC-2049','DD-MON-YYYY')
> *
>ERROR at line 3:
>ORA-00904: invalid column name
>
>
>I know that manpowerprofile.mpp_terminationdt is a valid table column. Do
I
>need to do some type of join on these two tables? Or is it just Friday
and
>I should give up and go have a cold beer!!:o) Any advice would be
>appreciated.
>
>Thanks,
>
>Dave
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Farnsworth, Dave
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Regina Harter
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajaram
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
NetZero Platinum
No Banner Ads and Unlimited Access
Sign Up Today - Only $9.95 per month!
http://www.netzero.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rajaram
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
