创建: create or replace procedure Sal_raise(emp_no number,shuliang number) as begin update emp set sal=sal + shuliang where empno=emp_no; end;调用: begin Sal_raise(7369,200); end;
create procedure tt(a number(10)) as begin delete from student where sno=a; dbms_output.put_line('学号为'||a||'的同学信息已被删除!'); end;
create procedure proc as begin dbms_output.put_line('hello world'); end; 调用: exec proc;
create or replace procedure Sal_raise(emp_no number,shuliang number)
as
begin
update emp set sal=sal + shuliang where empno=emp_no;
end;调用:
begin
Sal_raise(7369,200);
end;
as
begin
delete from student where sno=a;
dbms_output.put_line('学号为'||a||'的同学信息已被删除!');
end;
as
begin
dbms_output.put_line('hello world');
end;
调用:
exec proc;