ºÜ¼òµ¥µÄÎÊÌ⣬Çó¸ßÊÖÀ´£¬oracle Êý¾Ý¿âÃûÁбíµÄ»ñÈ¡
ÎÒÒª»ñÈ¡±¾»úÉÏÃæËùÓеÄÊý¾Ý¿âÃû£¬±¾»úÉÏÓÐ2¸öÊý¾Ý¿â ±ð¸æËßÎÒÓÃselect * from v$database»òÕßglobal_name»òÕßV$INSTANCE,ÄÇÖ»ÊÇÏÔʾµ±Ç°µÄÊý¾Ý¿âÃû£¬ Ò²²»Òª¸æËßÎÒÈ¥¶Átnsnames.oraÎļþ£¬ÄÇÌ«Âé·³ÁË£¬ Çó¸ßÊÖÖ¸µ¼¡£
×Ô¼ºÐ´¸ö³ÌÐò...¼òµ¥ÓÖ¿ì Ö»ÄܶÁtnsnames.oraÎļþ¡£ÒòΪÈç¹ûÒªÓÃSQL²éѯµÄ»°£¬Ò»°ã¶¼»áÐèÒªµÇ½¡£¶øµÇ½ÔòÐèÒªµÇ½µ½¾ßÌåµÄʵÀý²Å¿ÉÒÔдSQL²éѯ¡£ÒýÓà ×Ô¼ºÐ´¸ö³ÌÐò...¼òµ¥ÓÖ¿ì ×Ô¼ºÐ´¸ö³ÌÐò¡£¡£¡£¸üÂé·³ ¶à¸öÊý¾Ý¿âÏà¶Ô¶ÀÁ¢£¬²»ºÃ´ÓÊý¾Ý¿â±¾ÉíµÄ×Öµä±íÀ´È¡µÃ°É£¬ Ö»¿ÉÄÜ´Ó²Ù×÷ϵͳ·½ÃæµÄÅäÖÃÎļþÈ¥½â¾öÁË ²»ÖªµÀÕâ¸öÀïÃæÓÐûÓÐÄãÏëÒªµÄ¶«Î÷? SQL code: select SYS_CONTEXT('USERENV','TERMINAL') terminal, SYS_CONTEXT('USERENV','LANGUAGE') language, SYS_CONTEXT('USERENV','SESSIONID') sessionid, SYS_CONTEXT('USERENV','INSTANCE') instance, SYS_CONTEXT('USERENV','ENTRYID') entryid, SYS_CONTEXT('USERENV','ISDBA') isdba, SYS_CONTEXT('USERENV','NLS_TERRITORY') nls_territory, SYS_CONTEXT('USERENV','NLS_CURRENCY') nls_currency, SYS_CONTEXT('USERENV','NLS_CALENDAR') nls_calendar, SYS_CONTEXT('USER
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿ 1 ¿ÉÒÔɾ³ý 2 ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......