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´úÌæ¡£×ó»¹ÊÇÓÒ²»ÖªµÀ£¬²ËÄñÔÚ¿ª·¢ÖкÜÉÙÓõ½Õâ¸ö¡£ лл¸÷λµÄ»Ø´ð ÎÊÌâÒѽâ¾ö ½áÌû
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿ µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿ 3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
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 ......