創(chuàng)建包:

create or replace package p_view_param? is

function set_param(num number) return number;

function get_param? return number;

end p_view_param;

create or replace package body p_view_param is

paramValue number;

function set_param(num number) return number is

begin

paramValue:=num;

return num;

end;

function get_param return number is

begin

return paramValue;

end;

end p_view_param;

視圖的建立:

create or replace view p_view_user as ???? select id,realName,address from tbl_info where id=p_view_param.get_param(); ???? ??? PL/SQL調(diào)用: ???? select * from p_view_user where p_view_param.set_param(2781)=2781

總結(jié)

以上是生活随笔為你收集整理的oracle有入参的试图,Oracle 带参视图的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。