ORACLE¹ú¼ÊÈÏÖ¤Åàѵ
²©ÑåÅàѵ²¿ÊǹúÄÚΨһĿǰµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ŀǰ£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒÆ¶¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎÊÔÚÈ«ÊÀ½ç½öÓÐ1 ÍòÈË£¬ÔÚÖйú²»³¬¹ý°ÙÈË¡£Êг¡ÒѾ֤Ã÷£¬Äõ½Oracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎÊÔÚÖйúµÄÄêн¼¯ÖÐÔÚ20-50ÍòÈËÃñ±ÒÇø¼ä£¬×ÊÉîµÄ×Éѯ¹ËÎÊÄêнÉõÖÁ¸ß´ï°ÙÍò×óÓÒ£¬¶øÇÒ³ÊÏÖ³ÖÐøÉÏÕǵÄÌ¬ÊÆ¡£Ä¿Ç°Öйú Oracle ¸ß¼¶×Éѯ¹ËÎÊÈ˲ŵÄȱ¿ÚÔÚ10 ÍòÈË×óÓÒ£¬È˲Žôȱ״¿öÓɴ˿ɼû¡£
²©ÑåÅàѵ²¿¿ªÉè¿Î³Ì£º
Oracleµç×ÓÉÌÎñÌ×¼þ R12 ²ÆÎñ¹ÜÀí 5ÔÂ17ÈÕ¿ª¿Î È«ÈÕ°à
Oracleµç×ÓÉÌÎñÌ×¼þR12¹©Ó¦Á´¹ÜÀí 5ÔÂ17ÈÕ¿ª¿Î È«ÈÕ°à
Oracleµç×ÓÉÌÎñÌ×¼þR12 Ó¦Óù¤¾ßºÍ¼¼Êõ 5ÔÂ17ÈÕ¿ª¿Î È«ÈÕ°à
×Éѯµç»°£º010-82826100--2246 ºÂÀÏʦ
QQ£º297539145 QQȺ£º108882889
MSN:haoguojing01@hotmail.com
¸ü¶à¿Î³ÌÐÅÏ¢Çëµã»÷£ºhttp://edu.beyondsoft.com/products.asp?ClassID=97
¹Ù·½ÊÚȨ£¬ÖÊÁ¿±£Ö¤¡£
Ïà¹ØÎĵµ£º
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ......
JobµÄ²ÎÊý£º
Ò»£ºÊ±¼ä¼ä¸ôÖ´ÐУ¨Ã¿·ÖÖÓ£¬Ã¿Ì죬ÿÖÜ£¬:ÿÔ£¬Ã¿¼¾¶È£¬Ã¿°ëÄ꣬ÿÄ꣩
intervalÊÇÖ¸ÉÏÒ»´ÎÖ´ÐнáÊøµ½ÏÂÒ»´Î¿ªÊ¼Ö´ÐеÄʱ¼ä¼ ......
ÎÒÔÚ¹¤×÷ÖÐÔÚOracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðòʱ£¬ÓÃorder by ±íÃû.datatime desc ×ÜÊÇʵÏÖ²»ÁË¡£
²»¹ý×îºóÎÊÑî¾é×îºóºÍÎÒ˵¿ÉÒÔ°ÑÎÒÃDzéѯµÄ×ܸösqlÓï¾ä×öΪһ¸ö±íÀ´ÅÅÐò£º
select rownum,aa.* from (.... order by ±íÃû.datatime desc ) aa ......
ÉÏһƪÎÄÕÂдÁËÒ»¸öoracleµÄÒ»¸öÐÐתÁеÄÀý×Ó£¬ÀïÃæÓõ½ÁËoracleÖÐÖØÒªµÄº¯Êý decode,ÕâÆªÎÄÕ¾ÍÀ´¼òµ¥µÄѧϰÕâ¸öº¯Êý
DECODEº¯ÊýºÍÎÒÃÇÓïÑԽṹÖеÄÌõ¼þÓï¾ä£¨IF£©ÏàËÆ¡£Ëü½«ÊäÈëÊýÖµÓ뺯ÊýÖеIJÎÊýÁбíÏà±È½Ï£¬¸ù¾ÝÊäÈëÖµ·µ»ØÒ»¸ö¶ÔÓ¦Öµ¡£
DECODEº¯ÊýÏ൱ÓÚÒ»Ìõ¼þÓï¾ä(IF).Ëü½«ÊäÈëÊýÖµÓ뺯ÊýÖеIJÎÊýÁбíÏà±È½Ï£¬¸ù¾ÝÊ ......
½ñÌìÓöµ½Ò»¸öÎÊÌ⣬PERL ÒýÆðOracleÊý¾Ý¿â100% CPU£¬ÏµÍ³ÊÇenterprise linux 4 update 7 64 bit
²é¿´½ø³ÌÔÀ´ÊÇgridµÄagent¡£Ö»ÓÐÏÈÍ£µôgrid
./emctl stop agent
./opmn stopall
pkill -9 perl
È»ºóÔÙ¿´¿´ÓÐûÓÐʲôbug¡£ ÕâÊǸöbug£¬ ´òÁËpatch 5908032ºóºÃÏñÕý³£ÁË¡£
oracle 549 &nbs ......