入职1年三个月,没有达到当初自己进公司定的目标,心里慌得一批,比TM遇到Bug还慌。
愿新的一年再接再厉,为改变自己的命运而战斗!

select sum(t.seq) seq, nvl(t.content, 'By:200')
  from (select 1 as seq,
               (select decode(substr(to_char(sysdate, 'yyyymm'), 1),
                              '202001',
                              '一言:',
                              (select to_char(sysdate,
                                              'yyyy"年"mm"月"dd"日" hh24:mi:ss')
                                 from dual))
                  from dual) as content
          from dual
        union all
        select 2 as seq,
               (select case
                         when to_number(to_char(sysdate, 'yyyymmdd')) <
                              20200125 and
                              substr(to_char(sysdate, 'yyyymmdd'), 1, 4) =
                              '2020' then
                          (select '提前' || (select to_char(20200125) -
                                                  to_char(sysdate, 'yyyymmdd') ||
                                                  '天祝大佬们新年快乐'
                                             from dual)
                             from dual)
                         when to_number(to_char(sysdate, 'yyyymmdd')) between
                              '20200125' and '20200131' and
                              substr(to_char(sysdate, 'yyyymmdd'), 1, 4) =
                              '2020' then
                          (select '新年快乐,属(shu)你最棒' from dual)
                         when to_char(sysdate, 'yyyymmdd') > '20200131' and
                              substr(to_char(sysdate, 'yyyymmdd'), 1, 4) =
                              '2020' then
                          '工作使我快乐'
                         else
                          '如果不是真的垃圾,谁又甘愿混吃等死一年又一年'
                       end
                  from dual) || '!' content
          from dual) t
 group by cube(t.content)
 order by 1;
Last modification:March 21st, 2020 at 04:25 pm
如果觉得我的文章对你有用,请随意赞赏