摘要: CF_DEPTUCORGANIZATION INSERT UPDATE DELETE 触发器CREATE OR REPLACE TRIGGER tr_del_CF_DEPTUCORGANIZATIONBEFORE INSERT OR UPDATE OR DELETE ON CF_DEPTUCORGA 阅读全文
posted @ 2017-05-16 16:24 甜菜波波 阅读(512) 评论(0) 推荐(0) 编辑
摘要: create or replace procedure p_test(p_cur out sys_refcursor)asbegin open p_cur for select * from F_RELATION;end p_test;DECLARE test_cur sys_refcursor ; 阅读全文
posted @ 2017-05-16 15:37 甜菜波波 阅读(781) 评论(0) 推荐(0) 编辑
摘要: 1.无参存储过程 create or replace procedure test_procasv_total number(10);begin select count(*) into v_total from F_RELATION; DBMS_OUTPUT.put_line('总人数:'||v_ 阅读全文
posted @ 2017-05-16 15:00 甜菜波波 阅读(2421) 评论(0) 推荐(0) 编辑
摘要: declaremsg varchar2(100);num integer :=1;begin msg :='a';case msg when 'a' then dbms_output.put_line('1');else dbms_output.put_line('3');end case ;<<b 阅读全文
posted @ 2017-05-16 11:27 甜菜波波 阅读(135) 评论(0) 推荐(0) 编辑