Where there is love, I will be there.

参考示例：
--
create or replace view org_user_view as
select t.username,t.password from org_users;
comment on column org_user_view.username is '用户名;
comment on column org_user_view.password is '密码';

自己写的：
--
create or replace view v_material_stock as
with gift as
 (select c_id, c_name, c_materialposid
    from posjf_baseinfo
   where c_is_onshelves = '1'),
ins as
 (select initem.c_materialid, sum(i_num) as innum
    from posjf_in_storehouse ins, posjf_in_storehouse_item initem
   where ins.c_id = initem.c_id
     and ins.c_status = '0'
   group by initem.c_materialid),
outs as
 (select outitem.c_materialid, sum(i_num) as outnum
  &nbs