oracle×ÔÔö³¤ÁÐΪʲôÄÇôÂé·³?
ÎÒÉè¼ÆµÄÒ»¸öÊý¾Ý¿âÖдóÁ¿µÄ±íÖж¼°ÑÖ÷¼üÉè³É×ÔÔö³¤¡£ ÎÊÌâÒ»£ºÄѵÀÎÒÕæµÄҪÿÕÅ±í¶¼¶ÔÓ¦Ò»¸ö×ÔÔöÁкʹ¥·¢Æ÷Â𣿣¿Í´¿àÖС£ ÎÊÌâ¶þ£ºoracleÉèÖÃ×ÔÔö³¤¶ÔÐÔÄÜÊÇ·ñÓÐÓ°Ï죿ÔõÑùÐ޸ĺõ㣿 ÎÊÌâÈý£ºÉèÖô¥·¢Æ÷ÓÐʲôÓÅ»¯µÄ½â¾ö·½°¸Â𣿠ССϺÃ×£¬ÏÈлл¸÷λÁË¡£
ÐÖµÜ,µÈÄãÓõ½ÖªµÀΪʲôÐòÁÐ(SEQUENCE)±È´¥·¢Æ÷ºÍ×ÔÔö³¤ºÃµÄʱºò,Äã¾Í²»ÊÇϺÃ×ÁË,ºÇºÇ, ÐòÁоÍÊÇÐÔÄܺÃ,,,,, ´¥·¢Æ÷µÄ»°,¿ÉÒԲο¼ÎҵIJ©¿ÍµÄhttp://blog.csdn.net/java3344520/archive/2009/11/30/4907591.aspx Èç¹ûÄãÖ»ÊÇÿ¸ö±íÐèÒªÒ»¸öÖ÷¼ü¡£Õâ¸öÖ÷¼üÖ»Òª±£Ö¤Î¨Ò»£¬²»¹ØÐÄÊDz»ÊÇÿ´Î¼ÓÒ»¡£ Ò²¿ÉÒÔʹÓÃGUIDº¯Êý½â¾ö¡£ È¡µÃGUIDµÄº¯ÊýSYS_GUID()¡£µÃµ½Ò»¸öËæ»úµÄ16½øÖÆÐòÁУ¬±£Ö¤Î¨Ò»ÐÔ¡£ ʹÓÃoracle×ÔÉíµÄ×ÔÔö£¬¾³£»áÓöµ½±¨IDÖØ¸´´íÎó¡£½¨ÒéʹÓÃUUID Ö÷¼ü×ÔÔö³¤ÓÃsequence¾ÍÐÐÁË¡£ÎªÊ²Ã´»¹Òª´¥·¢Æ÷ÒýÓà ÎÒÉè¼ÆµÄÒ»¸öÊý¾Ý¿âÖдóÁ¿µÄ±íÖж¼°ÑÖ÷¼üÉè³É×ÔÔö³¤¡£ ÎÊÌâÒ»£ºÄѵÀÎÒÕæµÄҪÿÕÅ±í¶¼¶ÔÓ¦Ò»¸ö×ÔÔöÁкʹ¥·¢Æ÷Â𣿣¿Í´¿àÖС£ ÎÊÌâ¶þ£ºoracleÉèÖÃ×ÔÔö³¤¶ÔÐÔÄÜÊÇ·ñÓÐÓ°Ï죿ÔõÑùÐ޸ĺõ㣿 ÎÊÌâÈý£ºÉèÖô¥·¢Æ÷ÓÐʲôÓÅ»¯µÄ½â¾ö·½°¸Â𣿠ССϺÃ×£¬ÏÈлл¸÷λÁË¡£ Ö»Òª´´½¨ÐòÁоÍÐÐÁË£¡¸ù±¾²»ÓÃÔÙ´´½¨´¥·¢Æ÷ÁË£¡ 1.ÿ¸ö±í¶¼´´½¨Ò»¸öÐòÁС£ 2.ÏÓÂé·³µÄ»°£¬ËùÓÐ±í¶¼¹²ÓÃÒ»¸öÐòÁС£ ·´ÕýÐòÁеÄÖµ¿É´ï10µÄ27´Î·½£¬ÄãÕâ±²×ÓÊÇÓò»ÍêµÄÁË£¡ÎÞÂÛÄ㽨¶àÉÙÕÅ±í¡£
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......