单表分解

 

INSERT {all | first}

                               [when then]

                                     into [(col1,col2, ··· )]

                                     [values(val1,val2, ··· )]

                               [when then]

                                     into [(col1,col2, ···)]

                                     [values(val1,val2, ···)]

                               ···

                               ···

                               [when then]

                                     into [(col1,col2, ···)]

                                     [values(val1,val2, ···)]

                               [else

                                     into [(col1,col2, ···)]

                                     [values (val1,val2, ···)]

                               ]

               Subquery-definition;

 

 

SQL> Create table small_orders(order_id   number(12)   not null,

                                                              customer_id number(6) not null,

                                                              order_total   number(8,2),

                                                              sales_rep_id number(6)

                                                              );

SQL> Creat table medium_orders as select *  from small_orders;

SQL> Creat table large_orders as select *  from small_orders;

SQL>Create table  special_orders(order id number(12) not null,

                                                                 customer_id number(6),

                                                                 order_total number(8,2),

                                                                 sales_rep_id number(6),

                                                                 credit_limit number(9,2),

                                                                 cust_email   varchar2(30)

                                                                 );

 

Insert all

     when ottl < 10000 then

          into small_orders

     when ottl > 10000 and ottl < 20000 then

          into medium_orders

     when ottl> 20000 then

          into large_orders

     when ottl>29000 then

          into special_orders

      select o.order_id oid, o.customer_id cid, o.order_total ottl,

                   o.sales_rep_id sid, c.credit_limit cl, c.cust_email cem

      from orders o, customers

      where o.customer_id = c.customer_id;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7356664/viewspace-509514/，如需转载，请注明出处，否则将追究法律责任。

0

0

分享到：

上一篇： 多表合并

下一篇： 触发器

请登录后发表评论 登录

全部评论

<%=items[i].createtime%>

<%=items[i].content%>

<%if(items[i].items.items.length) { %>

<%for(var j=0;j

<%=items[i].items.items[j].createtime%> 回复

<%=items[i].items.items[j].username%>   回复   <%=items[i].items.items[j].tousername%>： <%=items[i].items.items[j].content%>

<%}%> <%if(items[i].items.total > 5) { %>

还有<%=items[i].items.total-5%>条评论) data-count=1 data-flag=true>点击查看

<%}%>

<%}%> <%}%>

junecaoic

注册时间：2008-12-09

博文量

14

访问量

9986

最新文章

EXPDP导出指定数据行 IMP导入表到默认表空间的操作 INSERT ALL和INSERT FIRST语法 安装OEM遇到问题ORA-06512的处理方法 ORACLE正则表达式 产生跟踪信息 oracle数据库审计 触发器 关于exception的学习笔记 物化视图

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号：11010802021510

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

转载于:http://blog.itpub.net/7356664/viewspace-509514/