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

Oracle Êý¾Ý¿âµÄ°²×°

 
   ×°ÁËÒ»Ò¹µÄÈí¼þ£¬ÏÈÊÇMySQL£¬myEclipse,Oracle ,²»¶ÏµÄ³ö´í£¬OracleServise²»ÄÜÆô¶¯£¬ºÜÊÇ·³ÈË£¬Ð¶ÔØÁËOracelÁ½´Î£¬ÓÖ֨װ£¬´íÎóµÃµ½Ò»Ð©½â¾ö£¬×¢²á±í³öÏÖÁ˺öàµÄÎÊÌ⣬ÒÔǰÔÚÐ¶ÔØÈí¼þµÄʱºò£¬¶¼Ã»ÓÐÓÃרÓõŤ¾ß£¬×¢²á±íÒ»ÍÅÂÒ£¬ÕæÊÇÏ൱µÄºó»Ú£¬ÏÖÔÚ¿´À´ÒªÏë¸Ä¹ýÀ´È·ÊµÊǺÜÄѵÄÀ²£¡ÒÔºóÕâ·½ÃæÒª¶à¼ÓµÄ×¢Òâ¿©¡£
      ÏÖÔÚÖÕÓڴ󹦸æ³É£¬ºÃÏë¿Þ£¡ ÕâÊÇÎÒµÚÒ»´ÎÕâÑùÏàÐÅ×Ô¼º£¬Ð»Ð»ÍøÓѵÄһЩ°ï£¬http://blog.csdn.net/xiaoyao6650/archive/2009/03/15/3989484.aspx£¬½ñÌìÓÖ×°ÁËVS2008£¬ÀÏÊÇÌø³öWEB×é¼þ°²×°Ê§°Ü£¬ÆøËÀÁË£¬
ÏÖÔÚÖÕÓÚ¸ãºÃÁË£¬Ô­À´ÊÇoffice_zh-cnµÄÎÊÌ⣬ÖÕÓڵõ½Á˽â¾ö¡£
       ÖÐÎç·¸Á˸ö´íÎó£¬ÌýÐÅÍøÓѵķ½·¨£¬ÐÞ¸ÄÁËÓû§µÄÕË»§£¬×îºó½øÈëF8²ÅµÃ½â¾ö£¬¿´À´µÃ×Ô¼º¶à¶¯¶¯ÄÔ×Óȥ˼¿¼°¡£¡
        ¾­ÀúÁËÕâЩÊÂÇ飬¸ü¼Ó¼á¶¨ÁË×Ô¼ºÒª×ߵķ£¬Chang,ÎÒÃÇÒ»ÆðŬÁ¦°É£¡ÏàÐÅ£¬ÎÒÏàÐÅÎÒÐеģ¬ÄãÒ²Ò»¶¨»áµÄ£¬²»ÊǵÄô£¬MyLove !


Ïà¹ØÎĵµ£º

OracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðò

ÎÒÔÚ¹¤×÷ÖÐÔÚOracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðòʱ£¬ÓÃorder by ±íÃû.datatime desc ×ÜÊÇʵÏÖ²»ÁË¡£
²»¹ý×îºóÎÊÑî¾é×îºóºÍÎÒ˵¿ÉÒÔ°ÑÎÒÃDzéѯµÄ×ܸösqlÓï¾ä×öΪһ¸ö±íÀ´ÅÅÐò£º
select rownum,aa.* from (....  order by ±íÃû.datatime desc ) aa ......

oracle¼òµ¥¶ÔÏóÀàÐÍ

ÔÚplsqlÖУ¬ÃæÏò¶ÔÏóµÄ³ÌÐòÉè¼ÆÊÇ»ùÓÚ¶ÔÏóÀàÐÍÀ´Íê³ÉµÄ¡£¶ÔÏóÀàÐÍÊÇÓû§×Ô¶¨ÒåµÄÒ»ÖÖ¸´ºÏÊý¾ÝÀàÐÍ£¬Ëü·â×°ÁËÊý¾Ý½á¹¹ºÍÓÃÓÚ²Ù×ÝÕâЩÊý¾Ý½á¹¹µÄ¹ý³ÌºÍº¯Êý£¬ÔÚ½¨Á¢¸´ÔÓÓ¦ÓóÌÐòʱ£¬Í¨¹ýʹÓöÔÏóÀàÐÍ¿ÉÒÔ½µµÍÓ¦Óÿª·¢ÄѶȣ¬½ø¶øÌá¸ßÓ¦Óÿª·¢µÄЧÂʺÍËÙ¶È¡£
¶ÔÏóÀàÐͰüÀ¨¶ÔÏóÀàÐ͹淶£¨object type specification£©ºÍ¶ÔÏóÀàÐÍ ......

Ð޸ĵçÄÔµÄÖ÷»úÃûoracle agent ·þÎñͻȻÎÞ·¨Æô¶¯

½ñÌìÓöµ½ÕâÑùµÄÎÊÌ⣬ÐÞ¸ÄÖ÷»úÃûºóoracle agent ·þÎñͻȻÎÞ·¨Æô¶¯£¬ÉÏÍøÕÒÁËÒ»»á×öÈçϲÙ×÷¡£¿ÉÒÔÕý³£Ê¹ÓÃÁË
1¡¢½«%oracle_home\ora92\network\adminϵÄlistener.oraºÍtnsnames.oraÄÚµÄËùÓÐÔ­Ö÷»úÃû¸ÄΪÏÖÓÐÖ÷»úÃû»òÕ߹̶¨IPµØÖ·£¨ÒÔ±ã¿Í»§¶Ë»úÆ÷Äܹ»·ÃÎÊServer£©£¬µ±È»Èç¹ûÏµÍ³ÖØÆôºó×Ô¶¯¸ÄÕý£¬¿ÉºöÂԴ˲½Öè¡£
2¡¢½«%o ......

ORACLE¹ú¼ÊÈÏÖ¤Åàѵ

²©ÑåÅàѵ²¿ÊǹúÄÚΨһĿǰµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
    Ŀǰ£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒÆ¶¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......

ORACLEµÄÈý¸öÅäÖÃÎļþ½éÉÜ


ÔÚoracle°²×°Ä¿Â¼$HOME/network/adminÏ£¬¾­³£¿´µ½sqlnet.ora tnsnames.ora
listener.oraÕâÈý¸öÎļþ£¬³ýÁËtnsnames.ora£¬ÆäËûÁ½¸öÎļþÏêϸµÄÓÃ;ºÜ¶àÈ˶¼²»Ì«Á˽⡣
sqlnet.ora ÓÃÔÚoracle client¶Ë£¬ÓÃÓÚÅäÖÃÁ¬½Ó·þÎñ¶ËoracleµÄÏà¹Ø²ÎÊý.
tnsnames.ora ÓÃÔÚoracle
client¶Ë£¬Óû§ÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄ±ðÃû²ÎÊý,¾ÍÏñÏµÍ³Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ