请教各位高手
如何写增删改查的语句。。是在包里写的。增删改返回的是整型希望能告诉下谢谢包的规范部分
create or replace package scott.stu_package is
type stu_cur_type is ref cursor;
包的主题部分
create or replace package body scott.stu_package is
拜托大家
如何写增删改查的语句。。是在包里写的。增删改返回的是整型希望能告诉下谢谢包的规范部分
create or replace package scott.stu_package is
type stu_cur_type is ref cursor;
包的主题部分
create or replace package body scott.stu_package is
拜托大家
RETURN NUMBER
AS
BEGIN
--INSERT INTO .....
--DELETE .....
--UPDATE .....
COMMIT;
RETURN 1 ;
EXCEPTION
WHEN OTHERS THEN
RETURN 0 ;
ROLLBACK;
END FUN_TEST;
end stu_package;
create or replace package scott.stu_package is
type stu_cur_type is ref cursor;
function addstu(stu_cur_type scott.student%rowtype) return number;
function deletstu(stu_cur_type scott.student%rowtype) return number;
function updatestu(stu_cur_type scott.student%rowtype) return number;
。。
查询 是 根据ID查询 返回 所有 信息。
我 只要方法的申明
create or replace package scott.stu_package is
Type v_Cur Is ref Cursor;
function querytest(id in number) Return v_Cur ;
.....
end stu_package ;包体:
create or replace package body scott.stu_package is
function querytest(id in number)
Return v_Cur ;
as
Cur v_Cur ;
begin
Open Cur For 'SELECT * FROM TABLE WHERE ID=''' || id || '''';
...
end;
end stu_package;