摘要:
/**********触发器 实例一***********/create or replace trigger my_triggers before insert or update or delete on users for each rowdeclare info varchar2(50);begin if inserting then info:='insert'; elsif updating then info:='update'; else info:='delete'; end if; dbms_output.put_line.. 阅读全文
摘要:
/*********实例一*********/create or replace procedure users_procedure is cursor users_cursor is select * from users;--声明动态游标 v_id users.id%type;--定义变量,与表中变量类型同步 v_username users.username%type; v_password users.password%type;begin open users_cursor;--打开游标 fetch users_cursor into v_id, v_username, ... 阅读全文