to_char(sysdate,'day')无法匹配('tuesday')问题
问题代码:
create or replace trigger securityemp
before insert
on emp
begin
if to_char(sysdate,'day') in ('tuesday') or
to_number(to_char(sysdate,'hh24')) not between 9 and 24 then
--禁止in...
原创
2018-12-18 20:36:08 ·
710 阅读 ·
0 评论