DATE_ADD(DATE_ADD(curdate(),INTERVAL +6 HOUR),INTERVAL +6 DAY) mysql取当前日期后6天,截止到6点钟的方法 --直接报错 CREATE OR REPLACE TRIGGER bef_gv_tickets BEFORE INSERT ON gv_tickets begin raise_application_error(-20002,'测试中,禁止插入tickets'); end; / --延时插入成功 --用sys执行 grant
PURPOSE ------- To explain how to disable Parallel Execution on Session/System level SCOPE & APPLICATION ------------------- DBA's and Support Analysts Disable Parallel Execution on Session Level ------------------------------------------
create or replace trigger forbid_ddl before ddl on DATABASEbegin --if ora_dict_obj_owner = ora_login_user then -- return; -- end if; raise_application_error (-20000, '零一二三四五六七八九零一二三四五六七八九零一二三四五六七八九零一二三四五六七八九零一二三四五六七八九零一二三四五六七八九零一二三四五六七八九零一二
alter system set remote_login_passwordfile=none scope=spfile; system默认:manager sys默认:change_on_install使用PL/SQL Plus登录数据库时,system用户使用密码manager可直接登录.但如果是sys用户,密码必须加上as sysdba,即sys用户使用密码change_on_install as sysdba才可登录.