<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 
    

    







    
	    
    




    








    

				

    



    







    
        
	



主站蜘蛛池模板：
国产精品亚洲αv天堂无码|
老色鬼久久亚洲AV综合|
国产精品成人免费视频网站京东|
国产精品亚洲片夜色在线|
免费中文字幕不卡视频|
久久青青草原国产精品免费|
国产成人亚洲精品|
亚洲色偷偷狠狠综合网|
999久久久免费精品国产|
国产午夜亚洲精品不卡电影|
老色鬼久久亚洲AV综合|
四虎精品亚洲一区二区三区|
最近免费最新高清中文字幕韩国|
精品亚洲av无码一区二区柚蜜|
亚洲精品一品区二品区三品区|
三年片在线观看免费大全|
eeuss在线兵区免费观看|
亚洲人成人77777在线播放|
亚洲欧洲日产国码高潮αv|
曰曰鲁夜夜免费播放视频|
久99久无码精品视频免费播放|
美女视频黄免费亚洲|
亚洲不卡中文字幕无码|
亚洲AV无码乱码在线观看性色扶
|
国产免费拔擦拔擦8x|
99视频在线免费|
精品人妻系列无码人妻免费视频
|
亚洲午夜精品第一区二区8050|
国产免费毛不卡片|
久久久久久久99精品免费|
美女被免费网站在线视频免费|
亚洲小说区图片区|
亚洲精品午夜国产VA久久成人|
白白国产永久免费视频|
9420免费高清在线视频|
a毛片全部免费播放|
老司机午夜免费视频|
亚洲色大情网站www|
亚洲综合激情视频|
久久久久亚洲av无码专区蜜芽
|
亚洲熟女少妇一区二区|