On 2003.11.16 17:04, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED]:avsp:9.2.0:OPS$ORACLE:81,43878>r 1 select case 2 when rtrim(to_char(sysdate,'DAY')) in ('SATURDAY','SUNDAY') 3 then 'Working from home' 4 else case 5 when to_char(sysdate,'HH24') between 8 and 17 6 then 'At work' 7 else 8 'Working from home' 9 end 10 end "Just another Day" 11* from dual
Just another Day ----------------- Working from home
Robert Eskridge
<[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> t> cc:
Sent by: Subject: Re: Test mesg
[EMAIL PROTECTED]
.com
11/16/2003 08:59
AM
Please respond to
ORACLE-L
JS> Just making sure the list is up.
I'm up. Though I didn't know we had hours we were supposed to be online on a Sunday.....
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
-- 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 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).
