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 閱讀(277) 評論(0)  編輯  收藏  所屬分類: Database 
          

          







          
	    
    




          








          

				

          



    







          
        
	




主站蜘蛛池模板：
葵青区|
体育|
鸡西市|
麻栗坡县|
新龙县|
芒康县|
岱山县|
泰来县|
峨山|
商都县|
类乌齐县|
梅河口市|
田阳县|
无极县|
灵宝市|
汉川市|
景德镇市|
凤凰县|
开封县|
中牟县|
泗水县|
呼和浩特市|
濮阳市|
霍林郭勒市|
泽州县|
九龙坡区|
大埔县|
墨江|
泌阳县|
富锦市|
华宁县|
郸城县|
元江|
泊头市|
平舆县|
韩城市|
林西县|
长兴县|
岑溪市|
金秀|
红桥区|