aline200的博客

create or replaceprocedure test as --建立游标 Cursor ss is select GROUP_NAME from SUMMARYLOG_LIST group by GROUP_NAME;BEGIN--for循环for b in ss loopBEGINif b.GROUP_NAME=null theninsert into AA(hong

--创建test存储过程create or replace procedure test as --建立游标 Cursor ss is select CALL_OBJ from MONITOR_LOG group by CALL_OBJ;BEGIN--for循环for b in ss loopBEGININSERT INTO AA(hongyan) SELECT count(SER

create or replaceprocedure test as --申明数组类型 type t_test is table of varchar2(9); test t_test:=t_test('A','B','C','D','E','F','G','H','J','K','L'); begin--遍历数组，将遍历得到的数据插入到AA表中 for i in 1 .. te

DML(insert,update,delete) , DDL(create,alter,drop)，instead of 触发器（作用于复杂视图），系统触发器--行触发器，create or replacetrigger test_delete before delete on test for each rowbegin Dbms_Output.Put_Line(:old.t

--oracle程序包分包头和包体--创建包头create or replace PACKAGE pak1 is --存储过程addnumberprocedure addnumber(x in number,y in NUMBER);--函数addfunctionfunction addfunction(x in number,y in NUMBER) RETURN numbe

--函数的创建 create or replaceFUNCTION addfunction(x in number,y out NUMBER) return number isresults NUMBER :=0;BEGINresults :=x+1; dbms_output.put_line(results);y :=x+2;return results;end;--创建函数的基