Oracle 创建视图(View)实例
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle 创建视图(View)实例,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2842字,纯文字阅读大概需要5分钟。
内容图文
语法:
create or replace 【ViewName】 asselect * from QueryTable[s]
实例:
create or replace view vm_wo asselect‘2‘as sources,wo_nbr,wo_lot,wo_cust,wo_part,wo_rel_date,wo_due_date,wo_qty_ord,wo_status,wo_line,wo_so_nbr,wo_so_line, wo_soft,wo_soft_ver,wo_rmks,wo_mod_date, (casewhen wop_ptsize like‘%LED%TV%‘then nvl(wopd1_capacity_ratio,0) when wop_ptsize like‘%LED%PANEL%‘then nvl(wopd2_capacity_ratio,0) else0end) wo_standard_ratio, round(decode(nvl(t.wo_rel_hour,0),0,0,(casewhen wop_ptsize like‘%LED%TV%‘then nvl(wopd1_capacity_ratio,0) when wop_ptsize like‘%LED%PANEL%‘then nvl(wopd2_capacity_ratio,0) else0end) * wo_qty_comp / t.wo_rel_hour),4) wo_standard_efficient, nvl(wo_std_pl,0) wo_standard_person, round(nvl(wo_man_haur,0),4) wo_standard_time from wo_mstr join pt_mstr on pt_part = wo_part join wop1_mstr on pt_size = wop_ptsize leftjoin wopd1_det on wopd1_nbr = wop_nbr and pt_cmt = wopd1_capacity_type leftjoin wopd2_det on wopd2_nbr = wop_nbr and pt_group = wopd2_capacity_type leftjoin ( select pzd_wo_nbr,pzd_wo_lot, nvl(sum(pzd_people_count*pzd_rel_hour),0) wo_rel_hour from pzd_det a join pz_mstr b on pz_nbr = pzd_nbr groupby pzd_wo_nbr,pzd_wo_lot ) t on t.pzd_wo_nbr = wo_nbr and t.pzd_wo_lot = wo_lot where1=1and trunc(sysdate,‘dd‘) between wop_start and wop_end unionallselect‘1‘as sources,wo_nbr,wo_lot,wo_cust,wo_part,wo_rel_date,wo_due_date,wo_qty_ord,wo_status,wo_line,wo_so_nbr,wo_so_line, wo_soft,wo_soft_ver,wo_rmks,wo_mod_date, (casewhen wop_ptsize like‘%LED%TV%‘then nvl(wopd1_capacity_ratio,0) when wop_ptsize like‘%LED%PANEL%‘then nvl(wopd2_capacity_ratio,0) else0end) wo_standard_ratio, round(decode(nvl(t.wo_rel_hour,0),0,0,(casewhen wop_ptsize like‘%LED%TV%‘then nvl(wopd1_capacity_ratio,0) when wop_ptsize like‘%LED%PANEL%‘then nvl(wopd2_capacity_ratio,0) else0end) * wo_qty_comp / t.wo_rel_hour),4) wo_standard_efficient, nvl(wo_std_pl,0) wo_standard_person, round(nvl(wo_man_haur,0),4) wo_standard_time from (select wo_nbr,wo_lot,wo_cust,wo_part,wo_rel_date,wo_due_date,wo_qty_ord,wo_status,wo_line,wo_so_nbr,wo_so_line, wo_soft,wo_soft_ver,wo_rmks,wo_mod_date,wo_std_pl,wo_man_haur,wo_qty_comp from huinan.wo_mstr@huinanerp) join huinan.pt_mstr@huinanerpon pt_part = wo_part join huinan.wop1_mstr@huinanerpon pt_size = wop_ptsize leftjoin huinan.wopd1_det@huinanerpon wopd1_nbr = wop_nbr and pt_cmt = wopd1_capacity_type leftjoin huinan.wopd2_det@huinanerpon wopd2_nbr = wop_nbr and pt_group = wopd2_capacity_type leftjoin ( select pzd_wo_nbr,pzd_wo_lot, nvl(sum(pzd_people_count*pzd_rel_hour),0) wo_rel_hour from huinan.pzd_det@huinanerp a join huinan.pz_mstr@huinanerp b on pz_nbr = pzd_nbr groupby pzd_wo_nbr,pzd_wo_lot ) t on t.pzd_wo_nbr = wo_nbr and t.pzd_wo_lot = wo_lot where1=1and trunc(sysdate,‘dd‘) between wop_start and wop_end;
原文:http://www.cnblogs.com/su1643/p/8004552.html
内容总结
以上是互联网集市为您收集整理的Oracle 创建视图(View)实例全部内容,希望文章能够帮你解决Oracle 创建视图(View)实例所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。