Oracle INSERT ALLºÍINSERT FIRST
½ñÌìµÚÒ»´ÎÖªµÀORACLEÔÀ´»¹¿ÉÒÔÕâÑùINSERTµÄ……³¤¼ûʶÁË
Ò»¡¢ÎÞÌõ¼þ INSERT ALL
¶þ¡¢Ìõ¼þ INSERT ALL
Èý¡¢Ìõ¼þ INSERT FIRST
Insert…Select
ʹÓÃInsert SelectʵÏÖͬʱÏò¶à¸ö±í²åÈë¼Ç¼
Ò»¡¢ÎÞÌõ¼þ INSERT ALL
---------------------------------------------------------------------------------------------
INSERT ALL
insert_into_clause values_clause_1
[insert_into_clause values_clause_2]
……
Subquery£»
----------------------------------------------------------------------------------------------
1¡¢Ö¸¶¨ËùÓиúËæ×ŵĶà±í insert_into_clauses Ö´ÐÐÎÞÌõ¼þµÄ¶à±í²åÈ룻
2¡¢¶ÔÓÚÿ¸öÓÉ×Ó²éѯ·µ»ØµÄÐУ¬ Oracle ·þÎñÆ÷Ö´ÐÐÿһ¸ö insert_into_clauseÒ»´Î¡£
¶þ¡¢Ìõ¼þ INSERT ALL
---------------------------------------------------------------------------------------------
INSERT ALL
WHEN condition THEN insert_into_clause values_clause
[WHEN condition THEN] [insert_into_clause values_clause]
……
[ELSE] [insert_into_clause values_clause]
Subquery£»
--------------------------------------------------------------------------------------------
1¡¢Ö¸¶¨ conditional_insert_clause À´Ö´ÐÐÒ»¸öÌõ¼þ¶à±í²åÈ룻
2¡¢Oracle ·þÎñÆ÷ͨ¹ýÏàÓ¦µÄ WHEN Ìõ¼þ¹ýÂËÿһ¸ö insert_into_clause£¬È·¶¨ÊÇ·ñÖ´ÐÐÕâ¸ö insert_into_clause£»
3¡¢Ò»¸öµ¥¸öµÄ¶à±í²åÈëÓï¾ä¿ÉÒÔ°üº¬×î¶à 127 ¸ö WHEN ×Ӿ䡣
Èý¡¢Ìõ¼þ INSERT FIRST
--------------------------------------------------------------------------------------------
INSERT FIRST
WHEN condition THEN insert_into_clause values_clause
[WHEN condition THEN] [insert_into_clause values_clause]
……
[ELSE] [insert_into_clause values_clause]
Subquery£»
--------------------------------------------------------------------------------------------
1¡¢Oracle ·þÎñÆ÷¶Ôÿһ¸ö³öÏÖÔÚÓï¾ä˳ÐòÖÐµÄ WHEN ×Ó¾äÇóÖµ£»
2¡¢Èç¹ûµÚÒ»¸ö WHEN ×Ó¾äµÄֵΪ true£¬Oracle ·þÎñÆ÷¶ÔÓÚ¸ø¶¨µÄÐÐÖ´ÐÐÏàÓ¦µÄ INTO ×Ӿ䣬²¢ÇÒÌø¹ýºóÃæµÄ WHEN ×Ó¾ä(ºóÃæµÄwhenÓï¾ä¶¼²»ÔÙ¿¼ÂÇÂú×ãµÚÒ»¸öWhen×Ó¾äµÄ¼Ç¼£¬¼´Ê¹¸Ã¼Ç¼Âú×ãwhenÓï¾äÖеÄ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
select 'create sequence '||sequence_name||
' minvalue '||min_value||
' maxvalue '||max_value||
' start with '||last_number||
&n ......
×÷Õߣº ÈÕÆÚ£º2005-12-8 1:43:32 À´Ô´£ºInternet µã»÷£º´Î ÆÀÂÛ
¡¡¡¡±¾ÎÄÖ»ÌÖÂÛOracleÖÐ×î³£¼ûµÄË÷Òý£¬¼´ÊÇB-treeË÷Òý¡£±¾ÎÄÖÐÉæ¼°µÄÊý¾Ý¿â°æ±¾ÊÇOracle8i¡£
¡¡¡¡Ò». ²é¿´ÏµÍ³±íÖеÄÓû§Ë÷Òý
¡¡¡¡ÔÚOracleÖУ¬SYSTEM±íÊÇ°²×°Êý¾Ý¿âʱ×Ô¶¯½¨Á¢µÄ£¬Ëü°üº¬Êý¾Ý¿âµÄÈ«²¿Êý¾ ......
¼ÇµÃÒÔÇ°ÉÏOCP¿Î³ÌµÄʱºòÄǸöÀÏʦ½ÌÎÒÃÇʹÓÃPROFILEÀ´ÏÞÖÆÓû§µÄһЩ²Ù×÷£¬ÄǸöʱºò¹À¼ÆÊÇÀÏʦ͵ÀÁ°É£¬ËùÓÐʵÑ鶼ÊÇͨ¹ýOEMµÄÐÎʽÀ´²Ù×÷£¬¸ù±¾²»»áÉæ¼°µ½ÃüÁîÐС£
ƽʱÔÚѧϰORACLEµÄ¹ý³ÌÖкÃÏñÒ²ºÜÉÙÅöµ½¹ØÓÚPROFILEµÄÎÊÌ⣬½ñÌì¹äÒ»¸öÅóÓѵÄBLOGµÄʱºò·¢ÏÖÕâƪÎÄÕ£¬¾õµÃͦºÃµÄ£¬ÄÚÈݲ»¶à£¬¼ò½àÃ÷ÁË£¬ºÃ´õÒ²ËãÊǸöÃüÁîÐÐ ......