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
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
SQL code: CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£ 2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£ 3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££» vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......