create view V_Accounts_UserRoles as select * from accounts_userroles,accounts_users,accounts_roles where accounts_userroles.userid = accounts_users.id(+) and accounts_userroles.roleid = accounts_roles.id(+) ;
create view V_Accounts_UserRoles as select * from accounts_userroles,accounts_users,accounts_roles where accounts_userroles.userid = accounts_users.id(+) and accounts_userroles.roleid = accounts_roles.id(+) ; ----------------------------------------------------------- 就是这么做!accounts_users和accounts_roles如果还有其它条件,他们的条件字段也要加上(+)。
select *
from accounts_userroles,accounts_users,accounts_roles
where accounts_userroles.userid = accounts_users.id(+)
and accounts_userroles.roleid = accounts_roles.id(+)
;
select *
from accounts_userroles,accounts_users,accounts_roles
where accounts_userroles.userid = accounts_users.id(+)
and accounts_userroles.roleid = accounts_roles.id(+)
;
-----------------------------------------------------------
就是这么做!accounts_users和accounts_roles如果还有其它条件,他们的条件字段也要加上(+)。