OracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðò
ÎÒÔÚ¹¤×÷ÖÐÔÚOracleÖжà±í²éѯÔÙ°´Ê±¼äµ¹Ðòʱ£¬ÓÃorder by ±íÃû.datatime desc ×ÜÊÇʵÏÖ²»ÁË¡£
²»¹ý×îºóÎÊÑî¾é×îºóºÍÎÒ˵¿ÉÒÔ°ÑÎÒÃDzéѯµÄ×ܸösqlÓï¾ä×öΪһ¸ö±íÀ´ÅÅÐò£º
select rownum,aa.* from (.... order by ±íÃû.datatime desc ) aa
Ïà¹ØÎĵµ£º
ÊÖ¶¯Æô¶¯Êý¾Ý¿â£º
Æô¶¯¼àÌý³ÌÐò£ºlsnrctl start
Æô¶¯Oracle·þÎñ£ºoradim -startup -sid orcl»òÕßnet start oracleserviceorcl
ÆäÖÐorclΪÊý¾Ý¿âµÄ·þÎñÃû»òÕßSID£¬oradim -startup -sid orclÕâ¸öÃüÁîÒÔǰ×Ô¼ºÃ»Óùý
ȨÏÞ¹ÜÀí£º
ϵͳȨÏÞ£º
create us ......
³éÏóÊý¾ÝÀàÐÍ£¬ÈÃOracleÊý¾Ý¿âÊý¾Ý¹ÜÀí¸ü¼ÓÈÝÒ×
×÷Õß: Victor, ¡¡³ö´¦:ITר¼ÒÍø,¡¡ÔðÈαà¼: °ü´ºÁÖ,¡¡
2009-02-04 10:10
¡¡¡¡ÐÕÃû£¬Æäʵ°üÀ¨Á½¸ö²¿·Ö£¬·Ö±ðΪÐÕÓëÃû¡£ÔÚûÓгéÏóÊý¾ÝÀàÐÍ֮ǰ£¬ÔÚÊý¾Ý¿âÉè¼ÆµÄʱºò£¬ÍùÍùÐèÒªÀûÓÃÁ½¸ö×Ö¶ÎÀ´±£´æÕâ¸öÐÕÃûÄÚÈÝ£¬ÈçFirst_nameÓëLast_nameµÈµÈ¡£ÕâÖ÷ÒªÊÇÒòΪÔںܶàʱºò£¬Ç°Ì¨ ......
OracleÆóÒµ¹ÜÀíÆ÷11gÌṩҵ½ç×îÈ«ÃæµÄÒµÎñÇý¶¯ÐÍIT¹ÜÀí¹¦ÄÜ£¬ÓÐÖúÓÚͨ¹ý¼¯³ÉʽIT¹ÜÀí·½·¨£¬×î´óÏ޶ȵØÌá¸ßÆóÒµÃô½ÝÐÔºÍЧÂÊ¡£
¡¡¡¡OracleÆóÒµ¹ÜÀíÆ÷11gÒýÈëÁË£º
¡¡¡¡ÒµÎñÇý¶¯ÐÍÓ¦ÓùÜÀí - ʹITϵͳÄܹ»¸ü¿ìµØÏìÓ¦ÓÅÏÈÒµÎñ£¬Í¨¹ý¹ÜÀíÃæÏòÓû§ÌåÑéºÍÉÌÎñ½»Ò׵ĹؼüÖ¸±ê£¬Ìṩ¸ü¸ßµÄÉÌÒµ¼ÛÖµ¡£
¡¡¡¡¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀ ......
ÿ´Îͨ¹ýÐÞ¸Ätnsnames.oraÅäÖñ¾µØNET·þÎñÃû¶¼³öÏÖ´íÎó“ORA-12154:TNS£¬ÎÞ·¨´¦Àí·þÎñÃû”£¬×ܵÃÓôÃÆ°ëÌì~
Õâ¸ö´íÎó£¬Í¨³£ÊÇÒòΪoracle±¾µØNET·þÎñÃûÅäÖÃtnsnames.oraÎļþÓÐÑϸñµÄ¸ñʽҪÇó¡£
ÀýÈ磺
mstrdw =
(DESCRIPTION =
(ADDRESS_LIST =
......