Oracle-L: Re: Test mesg

From: <Brian_P_MacLean_at_eFunds.Com>
Date: Sun, 16 Nov 2003 14:04:25 -0800
Message-ID: <F001.005D6DD1.20031116140425@fatcity.com>

SQL_at_phxux006: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                                                                                               
                      <bryny_at_dfweahs.ne        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                
                      t>                       cc:                                                                                  
                      Sent by:                 Subject:  Re: Test mesg                                                              
                      ml-errors_at_fatcity                                                                                             
                      .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: bryny_at_dfweahs.net

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





-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Brian_P_MacLean_at_eFunds.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 Sun Nov 16 2003 - 16:04:25 CST