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

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Ö®Ò»£º°²×°Oracle

°²×°¸ÅÊö
±¾Æª½éÉÜÈçºÎ°²×°OracleÈí¼þ£¬Òª°²×°OracleÈí¼þÍÆ¼öʹÓÃOracleͨÓð²×°¡£OracleͨÓð²×°³ÌÐòÊÇÒ»¸öͼÐÎÓû§½çÃæ£¨GUI£©¹¤¾ß£¬Ê¹Äú¿ÉÒԲ鿴OracleÈí¼þÒÑÔÚ¼ÆËã»úÉϰ²×°»ò°²×°ÐµÄOracleÈí¼þ£¬²¢Ð¶ÔØOracleÈí¼þ£¬ÒÔϽ«Ð­ÖúÄúÍê³É°²×°¹ý³Ì¡£
¼ì²éÏȾöÌõ¼þ
°²×°³ÌÐò֮ǰ£¬Oracle¹«Ë¾Ö´ÐÐÒ»¸öÏȾöÌõ¼þ¼ì²éµÄ×Ô¶¯±àº ......

oracle¼ÓÃܺ¯Êý

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm
oracle×Ô´øÎĵµÐ´µÄ±È½ÏÇå³þ
24

DBMS_CRYPTO
DBMS_CRYPTO
provides an interface to encrypt and
decrypt stored data, and can be used in conjunction with PL/SQL
programs running network communications. It provides suppo ......

oracle ²ã´Î»¯²éѯ

²ã´Î»¯²éѯ£º
select   [level],colomn,...from table
       [where where_clause]
       [   [start with start_condition]          [connect by prior prior_condition]&nbs ......

oracle systemÃÜÂëÍü¼Ç½â¾ö

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Êý¾Ý¿â£©

    Ô­ ÎÄ£ºÆ½·²ËêÔ£ºjiraµÄ°²×°£¨oracleÊý¾Ý¿â£©http://www.trucy.org/blog/ray/archives/000927.html
    
    ÒÔÏÂÊÇ»ùÓÚÔ­ÎĵIJ¹³äÍêÉÆºóµÄÄÚÈÝ£º
    JIRAÊÇÒ»¸öÓÅÐãµÄÎÊÌâ(or bugs£¬task£¬improvement£¬new feature  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ