OracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðò
ÎÒÔÚ¹¤×÷ÖÐÔÚOracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðòʱ£¬ÓÃorder by ±íÃû.datatime desc ×ÜÊÇʵÏÖ²»ÁË¡£
²»¹ý×îºóÎÊÑî¾é×îºóºÍÎÒ˵¿ÉÒÔ°ÑÎÒÃDzéѯµÄ×ܸösqlÓï¾ä×öΪһ¸ö±íÀ´ÅÅÐò£º
select rownum,aa.* from (.... order by ±íÃû.datatime desc ) aa
Ïà¹ØÎĵµ£º
Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚ ......
³éÏóÊý¾ÝÀàÐÍ£¬ÈÃOracleÊý¾Ý¿âÊý¾Ý¹ÜÀí¸ü¼ÓÈÝÒ×
×÷Õß: Victor, ¡¡³ö´¦:ITר¼ÒÍø,¡¡ÔðÈαà¼: °ü´ºÁÖ,¡¡
2009-02-04 10:10
¡¡¡¡ÐÕÃû£¬Æäʵ°üÀ¨Á½¸ö²¿·Ö£¬·Ö±ðΪÐÕÓëÃû¡£ÔÚûÓгéÏóÊý¾ÝÀàÐÍ֮ǰ£¬ÔÚÊý¾Ý¿âÉè¼ÆµÄʱºò£¬ÍùÍùÐèÒªÀûÓÃÁ½¸ö×Ö¶ÎÀ´±£´æÕâ¸öÐÕÃûÄÚÈÝ£¬ÈçFirst_nameÓëLast_nameµÈµÈ¡£ÕâÖ÷ÒªÊÇÒòΪÔںܶàʱºò£¬Ç°Ì¨ ......
¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀí£¬¼ò»¯¹ÜÀí»·¾³£¬Ìá¸ßͶ×ʻر¨ÂÊ
¡¡¡¡È«Ãæ¹ÜÀíOracleµÄ²úÆ·£¬°üÀ¨Äܹ»¹ÜÀíOracleÓ¦ÓÃÈí¼þ¡¢OracleÈÚºÏÖмä¼þ¡¢OracleÊý¾Ý¿â¡¢Oracle Solaris¡¢OracleÆóÒµ¼¶Linux¡¢Oracle VMºÍOracle Sun·þÎñÆ÷µÄ¹¤¾ß¡£ÕâʹµÃITÄܹ»¿ìËÙÈ·¶¨ÎÊÌâµÄ¸ù±¾ÔÒò£¬¶øÇÒÔںܶàÇé¿öÏ£¬»¹ÄÜ×Ô¶¯µØ½â¾öÎÊÌâ¡£
¡¡¡¡ÁíÍ⣬Õâ ......
ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
(DESCRIPTION =
(ADDRESS_LIST =
......
JobµÄ²ÎÊý£º
Ò»£ºÊ±¼ä¼ä¸ôÖ´ÐУ¨Ã¿·ÖÖÓ£¬Ã¿Ì죬ÿÖÜ£¬:ÿÔ£¬Ã¿¼¾¶È£¬Ã¿°ëÄ꣬ÿÄ꣩
intervalÊÇÖ¸ÉÏÒ»´ÎÖ´ÐнáÊøµ½ÏÂÒ»´Î¿ªÊ¼Ö´ÐеÄʱ¼ä¼ ......