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

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´Î·½£¬ÄãÕâ±²×ÓÊÇÓò»ÍêµÄÁË£¡ÎÞÂÛÄ㽨¶àÉÙÕÅ±í¡£





Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ