Oracle存储过程

---pl sql语句创建一个插入操作


--plsql语句
declare
begin
      insert into emp  values(9888,'bbb','SAAA',null,null,null,300,30);
      commit;  
end;     
      




--创建存储过程
create procedure isertEmp as
begin
      insert into emp  values(9888,'bbb','SAAA',null,null,null,300,30);
      commit;  
end;      




--替换存储过程
create or replace procedure isertEmp as
begin
      insert into emp  values(8889,'bbb','SAAA',null,null,null,300,30);
      commit;  
end;






--调用存储过程
set serveroutput on;


begin
    isertEmp;
end;












--替换存储过程
create or replace procedure isertEmp(
empnumber in number,
deptnumber in number)
as
begin
      insert into emp(empno,deptno) values(empnumber,deptnumber);
      commit;  
end;




--执行存储过程


exec isertEmp(1111,30);




--




select * from emp;




select ename from emp where empno=9999;




--执行查询
SQL> create or replace procedure selectEmpName(
  2    cno in number,
  3    cme out emp.ename%type
  4  )is
  5  begin
  6      select ename into cme from emp where empno=cno;
  7  end;
  8  /


variable cename varchar2(50);


begin
  selectempname(cempno=>9999,cename);
end