ÏëѧoracleÊý¾Ý¿â£¬Ôõô°ì£¿
ÎÒѧ¹ýsql server£¬ÏÖÔÚÏë×Ôѧoracle£¬ÈçºÎÏÂÊÖ£¿ÂòÊéºÃÂ𣿻¹ÊÇÍøÉÏÕÒ×ÊÁÏ£¿
Èç¹ûÂòÊéºÃ£¿½éÉܼ¸±¾ÊµÓÃÒ×¶®µÄ£¡Èç¹ûÍøÉÏѧºÃ£¬ÍƼöµã×ÊÁÏ¡£
Ìý˵ѧoracle 9i±È½ÏºÃ£¬ÎÒÏë°²×°ÄǸö£¬ÄÄÀïÓÐÏÂÔØµÄ£¿Ôõôװ£¿
ÎÒµÄÓÊÏäÊÇ£ºbobo_her_2999@163.com
QQ£º535241678
лл£¡£¡£¡
Ïëѧ¾Í¶àÁ·£¬¶àд£¬¶àʵ¼ù£¬³ý´ËÖ®Íâû±ðµÄÑ¡Ôñ¡£
9iºÍ10gµ½µ×ÄĸöºÃ£¿ÆóÒµÖÐÓÃÄĸö±È½Ï¶àѽ£¿
Ö÷Á÷10G°¡,²»¹ýѧϰµÄ»°½¨ÒéÓÃ11G°É,±È½ÏÏòϼæÈÝ
Ïëѧ¾Íѧ£¬Ïë³Ô¾Í³Ô!!
ÍÆ¼ö¼¸±¾Êé
»ù´¡µÄ£º
Oracle 10g ÈëÃÅÓëÌá¸ß
¾«Í¨Oracle 10g PL/SQL±à³Ì£¨ÍøÉÏÓеç×ÓÊ飩
OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏÈ«²áOracle Database 10g
½ø½×·½ÃæµÄ£º
oracleʵÓü¼ÊõÏê½â
Oracle 9i/10g±à³ÌÒÕÊõ
Oracle database 10g ÐÔÄܵ÷ÕûÓëÓÅ»¯
×îÈ«ºÍ×îȨÍþµÄ£º
oracle×Ô´øÎĵµ
Oracle database 10g »ù´¡½Ì³Ì £¨µÚ¶þ°æ£©
ÎÒÕýÔÚѧ..
¿ª·¢»¹ÊÇά»¤£¬ÏÖÔÚÖ÷Á÷µÄÊÇ10G£¬ÍâÃæµÄ×ÊÁÏÒ²ºÜ¶à£¬ËùÒÔѧϰ½¨ÒéÓÃ10gµÄ£¬Óöµ½ÎÊÌ⣬google Ò²ÄÜÕÒµ½´ð°¸¡£
¿ª·¢µÄ»°¾Í¶à¿´Ð©SQLµÄÊ飬ά»¤µÄ»°¾Í¿´¹ÜÀíµÄ¡£
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977
×Ô¼º°²×°Ò»¸ö10g£¬Ïë×Å·¨°ÑËû¸øÍæËÀÁË£¬È»ºóÏë×Å·¨¸øËû»Ö¸´¡£¡£È»ºóÄã¾ÍÊÇ´óÅ£ÁË¡£¡£
ÓÐSQL SER
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......