Question

在oracle 10g中如何用包+过程来实现对表增、删、改、插功能

先在这谢谢大家了，我在线等着答案。

Answer 1

以scott用户下的emp表为列：
创建TT包：
create or replace package TT
as
procedure p_insert(empno emp.empno%type,ename emp.ename%type);
procedure p_delete(vempno emp.empno%type);
procedure p_update(vempno emp.empno%type,vename emp.ename%type);
end TT;

创建包体：
create or replace package body TT
as
procedure p_insert(empno emp.empno%type,ename emp.ename%type)
as
begin
insert into emp(empno,ename) values(empno,ename);
end p_insert;
procedure p_delete(vempno emp.empno%type)
as
begin
delete from emp where empno=vempno;
end p_delete;
procedure p_update(vempno emp.empno%type,vename emp.ename%type)
as
begin
update emp set ename=vename where empno=vempno;
end p_update;
end TT;

调用相应的过程：
execute tt.p_insert(8888,'ALSANTE');
execute tt.p_delete(8888);
execute tt.p_update(8888,'MING');

Answer 2

试试用 plsql developer 工具，建立程序包，通过存储过程来处理