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

ºÜ¼òµ¥µÄÎÊÌ⣬Çó¸ßÊÖÀ´£¬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


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ