摘要:
1.查看所有用户: select * from dba_users; select * from all_users; select * from user_users; 2.查看用户或角色系统权限(直接赋值给用户或角色的系统权限): select * from dba_sys_privs; select * from user_sys_privs; (查看当前用户所拥有的... 阅读全文
摘要:
做一个表的insert的trigger,目的是只修改插入行的字段。 CREATE OR REPLACE TRIGGER TR_RME_SLOT BEFORE INSERT ON RME_SLOT FOR EACH ROW BEGIN IF (:NEW.POSITION >= 0 AND :NEW.POSITION = 0 AND :NEW.POSITION <10) THEN... 阅读全文