函数:
CREATE OR REPLACE
FUNCTION testFunc (num1 IN NUMBER, num2 IN NUMBER)
RETURN NUMBER
AS/IS
num3 number;
num4 number;
num5 number;
BEGIN
num3 := num1 + num2;
num4 := num1 * num2;
num5 := num3 * num4;
RETURN num5;
END;
--执行 select explainHello(1,2) from dual;
存储过程:
--创建存储过程
create or replace procedure proc_test(
num1 in Integer,
num2 in Integer,
type in Integer,
result out Integer
)
as
begin
if type=1 then
result := num1 + num2;
else if type=2 then
result:=num1 - num2;
else if type=3 then
result:=num1 * num2;
else if type=4 then
result:=num1/num2;
else
dbms_output.put_line('其他处理');
end if;
end;
查询锁表与解除方法
SELECT object_name, machine, s.sid, s.serial#
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid;
alter system kill session '24,111';
这是释放锁的语句
(其中24,111分别是上面查询出的sid,serial#)