oracle»Ø¹öÎÊÌ⣬ÔÚÏߵȼ±!!! - Oracle / ¿ª·¢ 
    
	
	¸Õ²Å×öÀ²Ò»¸ö¸üÐÂÓï¾ä£¬Íü¼Ç´øÌõ¼þÀ²°ÑÕû¸ö±í¶¼¸üÐÂÀ²¡£ÒªÔõô»Ø°ì
 ÖªµÀµÄ¼ÓÎÒQQлл375738283 10g  flashback 16¶Ô±íµÄʱ¼ä¶ÎÉÁ»Ø ±ØÐëÓÐȨÏÞ grant flashback any table to newtest ±ØÐëÏÈÖ´ÐÐalter table biao1 enable row movement; flashback table biao1 to timestamp to_timestamp('2010-5-31 11:53:17','yyyy-mm-dd hh24:mi:ss')ÒýÓà  ¸Õ²Å×öÀ²Ò»¸ö¸üÐÂÓï¾ä£¬Íü¼Ç´øÌõ¼þÀ²°ÑÕû¸ö±í¶¼¸üÐÂÀ²¡£ÒªÔõô»Ø°ì ±íÉÁ»Ø ÔÙ¸üлØÈ¥²»¾Í¿ÉÒÔÁËÒýÓà  ¸Õ²Å×öÀ²Ò»¸ö¸üÐÂÓï¾ä£¬Íü¼Ç´øÌõ¼þÀ²°ÑÕû¸ö±í¶¼¸üÐÂÀ²¡£ÒªÔõô»Ø°ì -- »¹Ã»commitµÄ»°£¬¾Írollback£»Èç¹ûÒѾcommitÁ˵ϰ£¬¾ÍÀûÓñíÉÁ»Ø(flastback)! -- ¶Ô£º¸üÐÂÌõ¼þÔõôдµÄ£¿ -- Ó¦¸Ã£ºÄÜÔÙ¸üлØÈ¥µÄÂï! -- µ±È»£ºÊÇ×Ö·ûÐ͵ϰ£¬ºÜÄѸüлØÈ¥! -- ÊýÖµÐ͵ϰ£¬ºÃµã! rollback һϠflashback  ֻҪûcommit ¾Írollback Ò»ÏÂÊÇ¿ÉÒÔ¶ÔÊÂÎñµÄ²Ù×÷½øÐлعöµÄ£¬¶ÔÓÚDDL£¨¶¨ÒåÓïÑÔ£©ÊÇÎÞЧµÄ°É£¡ÒýÓà  ֻҪûcommit ¾Írollback Ò»ÏÂÊÇ¿ÉÒÔ¶ÔÊÂÎñµÄ²Ù×÷½øÐлعöµÄ£¬¶ÔÓÚDDL£¨¶¨ÒåÓïÑÔ£©ÊÇÎÞЧµÄ°É£¡ -- ÊǵģºÊÇÎÞЧµÄ£¬µ«ÕâÊǸüÐÂÓï¾ä°¡!²»ÊôÓÚDDLÓïÑÔ°¡(CREATE/ALTER/DROP...)! Èç¹ûÊÇ10G ÒÔϰ汾 ÆÚÅÎÂ¥Ö÷ûÓÐCOMMIT  ¼ÙÈçûÓÐflashback, ¿ÉÒÔÊÔÊÔ logminer£¬»òÐíÄÜÕÒ»Ø ¼ÙÈçÊÇtruncateµÄ»°£¬¾Íû¾ÈÁË£¬µÃÓñ¸·ÝÀ´»¹Ô¡£ ¼ÙÈçÊÇdeleteµÄ»°£¬¿ÉÒÔÊÇ£ºflashback table T to timestamp t
    
 
	Ïà¹ØÎÊ´ð£º
        
    
    ¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ   http://www.oracle.com/technology/software/products/database/index.html   ------------------------------------------- ......
    
        
    
    ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
    
        
    
    ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ   Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
    
        
    
    ½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º SQL code:  update ibp_fund_information_tab set yield = 7.4520     where fund_code = '040003' and info_date =  ......