oracleÁÙʱ±íÏà¹Ø֪ʶ
ÔÚOracle8i»òÒÔÉÏ°æ±¾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT PRESERVE ROWS£»
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT DELETE ROWS£»
CREATE GLOBAL TEMPORARY TABLE MyTempTable
Ëù½¨µÄÁÙʱ±íËäÈ»ÊÇ´æÔڵģ¬µ«ÊÇÄãÊÔÒ»ÏÂinsert Ò»Ìõ¼Ç¼ȻºóÓñðµÄÁ¬½ÓµÇÉÏÈ¥select£¬¼Ç¼Êǿյģ¬Ã÷°×ÁË°É£¬ÎÒ°ÑÏÂÃæÁ½¾ä»°ÔÙÌùһϣº
--ON COMMIT DELETE ROWS ˵Ã÷ÁÙʱ±íÊÇÊÂÎñÖ¸¶¨£¬Ã¿´ÎÌá½»ºóORACLE½«½Ø¶Ï±í£¨É¾³ýÈ«²¿ÐУ©
--ON COMMIT PRESERVE ROWS ˵Ã÷ÁÙʱ±íÊǻỰָ¶¨£¬µ±ÖжϻỰʱORACLE½«½Ø¶Ï±í¡£
³åÍ»µÄÎÊÌâ¸ü±¾²»Óÿ¼ÂÇ.
ÁÙʱ±íÖ»ÊDZ£´æµ±Ç°»á»°(session)Óõ½µÄÊý¾Ý£¬Êý¾ÝÖ»ÔÚÊÂÎñ»ò»á»°ÆÚ¼ä´æÔÚ¡£
ͨ¹ýCREATE GLOBAL TEMPORARY TABLEÃüÁî´´½¨Ò»¸öÁÙʱ±í£¬¶ÔÓÚÊÂÎñÀàÐ͵ÄÁÙʱ±í£¬
Êý¾ÝÖ»ÊÇÔÚÊÂÎñÆÚ¼ä´æÔÚ£¬¶ÔÓڻỰÀàÐ͵ÄÁÙʱ±í£¬Êý¾ÝÔڻỰÆÚ¼ä´æÔÚ¡£
»á»°µÄÊý¾Ý¶ÔÓÚµ±Ç°»á»°Ë½ÓС£Ã¿¸ö»á»°Ö»ÄÜ¿´µ½²¢ÐÞ¸Ä×Ô¼ºµÄÊý¾Ý¡£DMLËø²»»á¼Óµ½
ÁÙʱ±íµÄÊý¾ÝÉÏ¡£ÏÂÃæµÄÓï¾ä¿ØÖÆÐеĴæÔÚÐÔ¡£
¡ñ ON COMMIT DELETE ROWS ±íÃûÐÐÖ»ÊÇÔÚÊÂÎñÆÚ¼ä¿É¼û
¡ñ ON COMMIT PRESERVE ROWS ±íÃûÐÐÔÚÕû¸ö»á»°ÆÚ¼ä¿É¼û
¿ÉÒÔ¶ÔÁÙʱ±í´´½¨Ë÷Òý£¬ÊÓͼ£¬³ö·¢Æ÷£¬¿ÉÒÔÓÃexportºÍimport¹¤¾ßµ¼Èëµ¼³ö±íµÄ
¶¨Ò壬µ«ÊDz»Äܵ¼³öÊý¾Ý¡£±íµÄ¶¨Òå¶ÔËùÓеĻỰ¿É¼û¡£
Temporary TablesÁÙʱ±í
1¼ò½é
ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
»òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
µ«ÊÇÁÙʱ±íµÄ½á¹¹ÒÔ¼°ÔªÊý¾Ý»¹´æ´¢ÔÚÓû§µÄÊý¾Ý×ÖµäÖС£
ÁÙʱ±íÖ»ÔÚoracle8iÒÔ¼°ÒÔÉϲúÆ·ÖÐÖ§³Ö¡£
2Ïêϸ½éÉÜ
OracleÁÙʱ±í·ÖΪ »á»°¼¶ÁÙʱ±í ºÍ ÊÂÎñ¼¶ÁÙʱ±í¡£
»á»°¼¶ÁÙʱ±íÊÇÖ¸ÁÙʱ±íÖеÄÊý¾ÝÖ»ÔڻỰÉúÃüÖÜÆÚÖ®ÖдæÔÚ£¬µ±Óû§Í˳ö»á»°½áÊøµÄʱºò£¬Ora
Ïà¹ØÎĵµ£º
Óαê(CURSOR),ºÜÖØÒª
Óαê:ÓÃÓÚ´¦Àí¶àÐмǼµÄÊÂÎñ
ÓαêÊÇÒ»¸öÖ¸ÏòÉÏÏÂÎĵľä±ú(handle)»òÖ¸Õë,¼òµ¥Ëµ£¬Óαê¾ÍÊÇÒ»¸öÖ¸Õë
1 ´¦ÀíÏÔʽÓαê
ÏÔʽÓα괦ÀíÐè 4¸ö PL/SQL ²½Öè,ÏÔʾÓαêÖ÷ÒªÓÃÓÚ´¦Àí²éѯÓï¾ä
(1) ¶¨ÒåÓαê
¸ñʽ: CURSOR cursor_name [(partment[,parameter]...)] IS s ......
Executive Overview
The Oracle Data Mining Option provides powerful data mining functionality within the Oracle Database. It enables you to discover new insights hidden in your data and to leverage your investment in Oracle Database technology. With Oracle Data Mining, you can build and apply ......
ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......
¡¡¡¡1´´½¨Ð±í
¡¡¡¡1.1´Ó²éѯµ½µÄ±í´´½¨±í
¡¡¡¡create table temp as select stuName,stuNo,stuSex from stuInfo where stuAge>25;
¡¡¡¡1.2´´½¨Ð±í
¡¡¡¡/*ѧÉúÐÅÏ¢±í*/
¡¡¡¡create table stuInfo(
¡¡¡¡stuName varchar2(10) ,
¡¡¡¡stuNo varchar2(10),
¡¡¡¡stuSex varchar2(4),
¡¡¡¡stuAge number(2),
¡¡¡¡st ......
´¥·¢Æ÷ trigger
·ÖÀࣺǰ´¥·¢£¬ºó´¥·¢
Ðд¥·¢Æ÷£¬Óï¾ä´¥·¢Æ÷
Ðд¥·¢Æ÷ÓëÓï¾ä´¥·¢Æ÷µÄÇø±ð£º
Ðд¥·¢Æ÷ÒªÇóµ±Ò»¸ö DML Óï¾ä²Ù×÷Ó°ÏìÊý¾Ý¿âÖеĶàÐÐÊý¾Ýʱ£¬¶ÔÓÚÆäÖеÄÿ¸öÊý¾ÝÐУ¬Ö»ÒªËüÃÇ·ûºÏ´¥·¢Ô¼ÊøÌõ¼þ£¬¾ù¼¤»îÒ»´Î´¥·¢Æ÷,FOR EACH ROW Ñ¡Ïî˵Ã÷´¥·¢Æ÷ΪÐд¥·¢Æ÷£»
Óï¾ä´¥·¢Æ÷ ......