关于实现带参数的视图
摘要:
--创建存储过程
create or replace package pkg_pv is
procedure set_pv(pv varchar2);
function get_pv return varchar2;
end;
create or replace package body pkg_pv is
v varchar2(20);
procedure set_pv(pv varchar2) is begin v:=pv; end;
function get_pv return varchar2 is begin return v; end;
end;
阅读全文
posted @ 2006-11-05 17:20 changhai-xuri 阅读(1969) 评论(0) 推荐(0) 编辑