创建视图时，可不可以对基本表的某条记录进行值得判断，然后选择值大于0的属性作为视图的属性，如下图：

Question

创建视图时，可不可以对基本表的某条记录进行值得判断，然后选择值大于0的属性作为视图的属性，如下图：

 

麻烦理解了我意思的大侠直接写出SQL语句吧!

Answer 1

oracle下通过以下方式解决：
[code="java"]
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 ru.* from rbac_user ru where ru.id=p_view_param.get_param();

select * from p_view_user where p_view_param.set_param(40)=40
[/code]