左右连接的另外一种写法



刚刚实习，这是公司的左右连接规范，左连接以（+）结尾，右连接以（-）结尾

create or replace view view_user as
select t.id,t.name,t.age ,b1.name as gender
  from demo_user t ,
       (select db.* from dic_base db where db.dtype = 'TY')b1
  where t.gender = b1.code(+);