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

Googleb²»µ½µÄOracle»ù±¾ÎÊÌâ

SELECT DECODE(TableName3.ColumnName1, 'PRTY', TableName2.ColumnName3)
from  TableName3
WHERE TableName1.ColumnName1(+) = TableName2.ColumnName2

Õâ¸öwhere×Ó¾äÖеÄ(+)Æðʲô×÷Óã¿Google²»µ½£¬°Ù¶ÈҲûÓС£¡£囧
from ÀïÃæ¼¸¸ö±íÃûд©ÁË¡£¡£¡£Ã»¹ØÏµ£¬Ö»ºÍwhere×Ó¾äÏà¹Ø¡£¡£¡£

ÕâÊÇoracleÓÒÁ¬½Ó±ê¼Ç

ÓÒÁ¬½Ó£¬×óÁ¬½ÓµÄ±ê¼Ç
Ï൱ÓÚright join TableName1 on  TableName1.ColumnName1 = TableName2.ColumnName2

Right outer join?
¼ÓºÅÔڵȺÅÇ°ÃæµÄÊÇÓÒÁ¬½Ó£¬ÔÚ×îºóÃæÊÇ×óÁ¬½Ó£¿

ÒýÓÃ
Right outer join?
¼ÓºÅÔڵȺÅÇ°ÃæµÄÊÇÓÒÁ¬½Ó£¬ÔÚ×îºóÃæÊÇ×óÁ¬½Ó£¿

ºÃÏñ¼ÓÔÚÄĸö×ֶκóÃæ£¬¾Í±íʾ¶ÔÓ¦µÄ×Ö¶ÎÈç¹û²»´æÔÚ£¬¾ÍÒÔnull´úÌæ¡£×ó»¹ÊÇÓÒ²»ÖªµÀ£¬²ËÄñÔÚ¿ª·¢ÖкÜÉÙÓõ½Õâ¸ö¡£

лл¸÷λµÄ»Ø´ð ÎÊÌâÒѽâ¾ö
½áÌû


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

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

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

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

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ