一 存储过程的基本应用
1 创建存储过程(SQL窗口)
create or replace procedure update_staff
as
begin
update staff set name = 'xy';
commit;
end update_staff;
存储过程适合做更新操作，特别是大量数据的更新
2 查看存储过程在数据字典中的信息(SQL窗口)...
先来一个简单的例子,有个感性认识.
create or replace procedure test is
aa number; begin select count(*) into aa from t_server_server;
DBMS_OUTPUT.PUT_LINE(aa); insert into test_test values(1,'aaa'); commit; en...
执行存储过程时，execute和call的区别
EXEC is a sqlplus command that put its argument as an anonymous pl/sql block: 'EXEC xxx' is transformed to 'BEGIN xxx; END;' So you can use it to call a procedure, or do any ...
