ºÜ¼òµ¥µÄÎÊÌ⣬Çó¸ßÊÖÀ´£¬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
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......