分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
- 创建包:
- 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调用:
- select * from p_view_user where p_view_param.set_param(2781)=2781