oracle µÄ left/right joinÓë(+)µÄÒ»¸öÇø±ð
»ù±¾´ÓÀ´²»ÓÃleft/right join
Ò»¸öÏîÄ¿±»ÆÈÒªÓñðÈËдµÄ sql
±¾´òËã¸ÄдһÏ£¬Ìá¸ßЧÂÊ
·¢ÏÖ£º
¡¾1¡¿
select * from a
left outer join b on a.id= b.id AND ...1...
where ...2...
Óë
¡¾2¡¿
select * from a , b
where a.id= b.id(+)
AND ...1...
AND ...2...
µÄÒ»¸öÇø±ð£º¡¾1¡¿ÀïµÄbÏ൱ÓÚ(select b.* where...1...)
Ïà¹ØÎĵµ£º
ÓÃOracle Sql Developer²Ù×÷±íµÄʱºò£¬²»ÖªÕ¦µÄ°Ñ±íËøסÁË¡£
½á¹ûÄÇÕűíÒ»²åÊý¾Ý¾ÍËÀ£¬Á¬truncate¶¼²»ÐС£
´ÓÍøÉÏÆßÆ´°Ë´ÕÁ˸ö·½·¨£¬ÖÕÓڰѽø³ÌɱÁË£¬±íÒ²¾Í½âËøÁË¡£
Ê×ÏÈÒªÓÃdba¼¶±ðµÄÓû§²Ù×÷£¬ÒòΪҪ²ì¿´ºÜ¶àϵͳ±í¡£ÓÃÆÕͨÓû§²Ù×÷µÄ»°£¬»áÌáʾ±í»òÕßView²»´æÔÚ¡££¨ÎªÊ²Ã´²»ÌáʾȨÏÞ²»¹»£¿º¦ÎÒ×ÜÒÔΪÊÇ°æ±¾ÎÊÌ⣩
È ......
1.ÓÃOracleÓû§µÇ½Linux·þÎñÆ÷;
2.ÔÚÖն˴°¿ÚÊäÈë sqlplus /nolog
[oracle@hylinux ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 7ÔÂ 29 14:26:16 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
& ......
Ô ÎÄ£ºÆ½·²ËêÔ£ºjiraµÄ°²×°£¨oracleÊý¾Ý¿â£©http://www.trucy.org/blog/ray/archives/000927.html
ÒÔÏÂÊÇ»ùÓÚÔÎĵIJ¹³äÍêÉƺóµÄÄÚÈÝ£º
JIRAÊÇÒ»¸öÓÅÐãµÄÎÊÌâ(or bugs£¬task£¬improvement£¬new feature  ......
ÍøÉÏÓкܶà×ÊÁÏ£¬Ò²ÊDzο¼eygleµÄÎĵµ¡£
OS : Redhat AS 4 U5
DB : Oracle 10.2.0.3
1.ÐÞ¸Äjdk ÏÂÃæµÄ×ÖÌå¡£
[oracle@rac2 db_1]$ cd $ORACLE_HOME/jdk/jre/lib/
[oracle@rac2 lib]$ mv font.properties font.properties_bak
[oracle@rac2 lib]$
[oracle@rac2 lib]$ cp font.properties.zh_CN.Redhat font.propertie ......