Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE UNDO ¡¶ÉîÈëdz³öORACLEµÚÆßÕ¡·

Èç¹û˵RedoÊÇÓÃÀ´±£Ö¤ÔÚ¹ÊÕÏʱÊÂÎñ¿ÉÒÔ±»»Ö¸´£¬ÄÇôUndoÔòÊÇÓÃÀ´±£Ö¤ÊÂÎñ¿ÉÒÔ±»»ØÍË»òÕß³·Ïú¡£
ÔÚÐ޸IJÙ×÷ÖУ¬¶ÔÓÚ»ØÍ˶εIJÙ×÷´æÔÚ¶à´¦£¬ÔÚÊÂÎñ¿ªÊ¼Ê±£¬Ê×ÏÈÐèÒªÔڻعö¶Î±í¿Õ¼ä»ñµÃÒ»¸öÊÂÎñ²Û£¬·ÖÅä¿Õ¼ä£¬È»ºó´´½¨Ç°¾µÏñ£¬´ËºóÊÂÎñµÄÐ޸IJÅÄܽøÐУ¬Oracle±ØÐëÒÔ´ËÀ´±£Ö¤ÊÂÎñÊÇ¿ÉÒÔ»ØÍ˵ġ£
Èç¹ûÓû§Ìá½»ÁËÊÂÎñ£¬Oracle»áÔÚÈÕÖ¾Îļþ¼Ç¼Ìá½»£¬²¢ÇÒд³öÈÕÖ¾£¬Í¬Ê±»áÔڻعö¶ÎÖаѸÃÊÂÎñ±ê¼ÇΪÒÑÌá½»£»Èç¹ûÓû§»Ø¹öÊÂÎñ£¬ÔòOracleÐèÒª´Ó»Ø¹ö¶Î°Ñǰ¾µÏñÊý¾Ý¶ÁÈ¡³öÀ´£¬ÐÞ¸ÄÊý¾Ý»º³åÇø£¬Íê³É»Ø¹ö£¬Õâ¸ö¹ý³Ì±¾ÉíÒ²Òª²úÉúRedo£¬ËùÒÔ»ØÍËÕâ¸ö²Ù×÷ÊǺܰº¹óµÄ¡£
ÔÚOracleÐÔÄÜÓÅ»¯ÖУ¬ÓÐÒ»¸öÐÔÄÜÖ¸±ê³ÆÎªÆ½¾ùÊÂÎñ»Ø¹öÂÊ£¨Rollback per transaction£©£¬ÓÃÀ´ºâÁ¿Êý¾Ý¿âµÄÌá½»Óë»Ø¹öЧÂÊ¡£¿ÉÒÔÔÚStatspackÖÐÕÒµ½Õâ¸öÖ¸±ê¡£
¸Ã²ÎÊý¼ÆË㹫ʽΪ£º
Round(User rollbacks/(user commits+user rollbacks),4)*100%
ÆäÖÐuser commitsºÍuser rollbacksÊý¾ÝÀ´×ÔϵͳµÄͳ¼ÆÐÅÏ¢£¬¿ÉÒÔ´Óv$sysstatÊÓͼÖеõ½£¬
SQL> select name,value from v$sysstat
 2 where name in ('user commits','user rollbacks');
 
NAME                                                                 VALUE
---------------------------------------------------------------- ----------
user commits                                                             5
user rollbacks                                  


Ïà¹ØÎĵµ£º

OracleºÍMSSQLÖÐÑ­»·µÄʹÓÃ


 ORACLE
CREATE OR REPLACE FUNCTION SETSTATE(OLDVALUE VARCHAR2, POS NUMBER, SVALUE VARCHAR2)
RETURN VARCHAR2
IS
RETURN_VALUE VARCHAR2 (20);
LEN NUMBER(8);
I NUMBER(8);
TEMP_VALUE VARCHAR2(1);
BEGIN
     LEN := LENGTH(OLDVALUE);
     IF POS > ......

ѧºÃOracleÁùÌõ×ܽá

 
1¡¢Èç¹ûÓÐÒ»¶¨µÄÊý¾Ý¿â»ù´¡£¬ÖªµÀSQLÊÇÔõô»ØÊ£¬¼´Ê¹Ð´²»³öÀ´¼òµ¥µÄSQL£¬µ«¿ÉÒÔ¿´¶¯ËüÃÇ£¬Äã¾Í¿ÉÒÔÌøµ½2¡£·ñÔòÇëÏÈ¿´Ò»ÏÂÊý¾Ý¿â»ù´¡ºÍSQLÓïÑÔ£¬²»ÐèÒªºÜÉ¸ü²»ÐèҪȥ¼ÇÒäÄÇЩ¸´ÔÓµÄSQLÃüÁÕâЩ¿ÉÒÔÁôÔÚÒÔºó±ßÓ¦Óñßѧϰ¡¢¼ÇÒä¡£
¡¡¡¡
¡¡¡¡2¡¢ÒªÏëѧºÃORACLE£¬Ê×ÏÈҪѧϰORACLEµÄÌåϵ½á¹¹£¬ÏÖÔÚÄã²»ÐèÒªÉîÈëÀ ......

ORACLE to_charº¯ÊýÏê½â

 The following are number examples for the to_char function.
to_char(1210.73, '9999.9')
would return '1210.7'
to_char(1210.73, '9,999.99')
would return '1,210.73'
to_char(1210.73, '$9,999.00')
would return '$1,210.73'
to_char(21, '000099')
would return '000021'
The following is a list ......

oracleÖÐʵÏÖÖ÷¼ü×Ô¶¯Éú³É

 IDÊÇÖ÷½¡£¬ÊµÏÖ²åÈëÒ»¸öNAME,ID×Ô¶¯Ôö¼Ó
SQL>   create   table   t1  
      2     (  
      3         id    & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ