<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        


    

    
	
	


    
	
    
		Jcat
    
		寵辱不驚，閑看庭前花開花落～～
	
    

    
    		
	

    

    


    
	
		
    
			


    
posts - 173,comments - 67,trackbacks - 0


    
	

    


    
	
					


    
	
	Most INSERT statements are the single-table variety, but Oracle also supports a multiple-table INSERT statement. With a multitable insert, you can make a single pass through the source data and load the data into more than one table.

    [ ALL | FIRST ]
    WHEN condition THEN insert_into_clause [values_clause]
    [insert_into_clause [values_clause]]...
    [WHEN condition THEN insert_into_clause [values_clause]
    [insert_into_clause [values_clause]]...
    ]...
    [ELSE insert_into_clause [values_clause]
    [insert_into_clause [values_clause]]...
    ]

    If a WHEN condition evaluates to TRUE, the corresponding INTO clause is executed. If no WHEN condition evaluates to TRUE, the ELSE clause is executed. The keyword ALL tells the database to check each WHEN condition. On the other hand, the keyword FIRST tells the database to stop checking WHEN conditions after finding the first TRUE condition.


    --test?case
    create?table?insert_test_case
    (
    id?    number(1)
    )

    create?table?insert_test01
    (
    id?    number(1)
    )

    create?table?insert_test02
    (
    id?    number(1)
    )

    create?table?insert_test03
    (
    id?    number(1)
    )

    insert?into?insert_test_case?values(1)
    insert?into?insert_test_case?values(2)
    insert?into?insert_test_case?values(3)
    insert?into?insert_test_case?values(4)
    insert?into?insert_test_case?values(5)


    --3 rows inserted
    insert?first?
    ??    when?id=1?then?into?insert_test01?values(id)
    ??    when?id=2?then?into?insert_test02?values(id)
    ??    when?id=3?then?into?insert_test03?values(id)
    select?id?from?insert_test_case

    --3 rows inserted
    insert?all
    ??    when?id=1?then?into?insert_test01?values(id)
    ??    when?id=2?then?into?insert_test02?values(id)
    ??    when?id=3?then?into?insert_test03?values(id)
    select?id?from?insert_test_case


    --1 rows inserted
    insert?first
    ??    when?id=1?then?into?insert_test01?values(id)
    ??    when?id=1?then?into?insert_test02?values(id)
    ??    when?id=1?then?into?insert_test03?values(id)
    select?id?from?insert_test_case

    --3 rows inserted
    insert?all
    ??    when?id=1?then?into?insert_test01?values(id)
    ??    when?id=1?then?into?insert_test02?values(id)
    ??    when?id=1?then?into?insert_test03?values(id)
    select?id?from?insert_test_case
    
	
    posted on 2006-12-13 13:32 Jcat 閱讀(273) 評論(0)  編輯  收藏  所屬分類: Database 
    

    







    
	    
    




    








    

				

    



    







    
        
	



主站蜘蛛池模板：
99久久精品日本一区二区免费|
美女被爆羞羞网站在免费观看
|
亚洲Av无码国产情品久久|
在线综合亚洲中文精品|
最近中文字幕mv免费高清电影|
亚洲国产成a人v在线观看
|
99爱视频99爱在线观看免费|
国产AV无码专区亚洲A∨毛片|
久久免费观看国产精品|
久久国产精品亚洲综合|
84pao强力永久免费高清|
亚洲熟妇色自偷自拍另类|
久久经典免费视频|
亚洲国产欧美一区二区三区|
免费日韩在线视频|
国产高清对白在线观看免费91
|
亚洲伦理中文字幕|
日韩免费毛片视频|
国产精品免费大片一区二区|
亚洲一区AV无码少妇电影☆|
9277手机在线视频观看免费|
亚洲国产精品综合久久20|
免费一级毛片清高播放|
一级人做人a爰免费视频|
亚洲Av熟妇高潮30p|
九九九精品成人免费视频|
亚洲狠狠婷婷综合久久|
亚洲综合精品网站|
51在线视频免费观看视频|
亚洲jizzjizz少妇|
久久亚洲综合色一区二区三区
|
aa在线免费观看|
亚洲国产精品自在线一区二区|
精品久久久久久久久免费影院|
国产精品亚洲一区二区三区|
亚洲人成亚洲人成在线观看|
在线观看免费高清视频|
亚洲阿v天堂在线2017免费|
亚洲精品无码久久久久久久|
亚洲AV蜜桃永久无码精品|
91精品国产免费入口|