[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).
