<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 
    

    







    
	    
    




    








    

				

    



    







    
        
	



主站蜘蛛池模板：
亚洲日韩精品国产一区二区三区|
国产亚洲欧洲精品|
色老板亚洲视频免在线观|
69视频免费在线观看|
久久精品国产亚洲|
一级毛片全部免费播放|
亚洲AV日韩AV天堂久久|
美女被cao网站免费看在线看|
国产AV无码专区亚洲精品|
青柠影视在线观看免费|
久久精品国产亚洲AV网站|
一级做a爰全过程免费视频|
亚洲精品美女在线观看|
性短视频在线观看免费不卡流畅|
久久亚洲精品国产精品婷婷|
日本高清免费不卡在线|
免费一级特黄特色大片|
亚洲日韩精品无码专区网址|
国产成人精品一区二区三区免费|
久久久久亚洲Av无码专|
久久精品a一国产成人免费网站|
久久亚洲欧美国产精品|
国产成人精品曰本亚洲79ren|
久久免费视频精品|
亚洲AV无码精品蜜桃|
国产男女猛烈无遮挡免费视频|
日韩在线视频免费|
亚洲美女人黄网成人女|
www.黄色免费网站|
国产成人高清亚洲一区91|
亚洲精品字幕在线观看|
黄色成人免费网站|
美女裸体无遮挡免费视频网站|
亚洲AV日韩精品久久久久久久
|
亚洲中文字幕在线乱码|
免费无遮挡无码永久视频|
亚洲人精品亚洲人成在线|
亚洲精品国产精品国自产观看|
久久久久国产免费|
亚洲乱码中文字幕在线|
国产亚洲高清不卡在线观看|