Hey! that looks like my switch_logfile proc (scheduled with dbms_job), which I still like better than archive_lag_target (except that it only looks at the first character being an 'S')
Why generate a log every half hour over the weekend?
Pd
[EMAIL PROTECTED] wrote:
[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] <[EMAIL PROTECTED] ORACLE-L list of recipients Multiple To:>
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
