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

Oracle ×óÁ¬½Ó ÓÒÁ¬½Ó

1. select * from t1 left join t2 on t1.c1 = t2.c2
ÊÇ×ó±ßµÄ±í£¨t1£© È«²¿ÏÔʾ£¬t2ûÓеÄÓÃnull´úÌæ¡£ ÓÒÁ¬½ÓÏà·´£¨t2£©
2. £¨+£©µÄÁ¬½ÓʱÁíÒ»¸öÈ«²¿ÏÔʾ¡£
select * from t1 left join t2 on t1.c1 = t2.c2 ºÍ select * from a,b where t1.c1 = t2.c2(+) Ч¹ûÒ»Ñù¡£
3. FULL OUTER JOIN:È«Íâ¹ØÁª
¡¡¡¡SELECT e.last_name, e.department_id, d.department_name
¡¡¡¡from employees e
¡¡¡¡FULL OUTER JOIN departments d
¡¡¡¡ON (e.department_id = d.department_id);
¡¡¡¡½á¹ûΪ:ËùÓÐÔ±¹¤¼°¶ÔÓ¦²¿ÃŵļǼ£¬°üÀ¨Ã»ÓжÔÓ¦²¿ÃűàºÅdepartment_idµÄÔ±¹¤¼Ç¼ºÍûÓÐÈκÎÔ±¹¤µÄ²¿ÃżÇ¼¡£


Ïà¹ØÎĵµ£º

oracleÖÐnvarchar2×Ö·û¼¯²»Æ¥Åä

oracleµ±¶à±íunionʱÓöµ½nvarchar2ÀàÐÍʱ±¨´í ×Ö·û¼¯²»Æ¥Åä
¶ÔʹÓÃnvarcharµÄµØ·½£¬¼ÓÉÏ to_char( nvarchar µÄ±äÁ¿»ò×Ö¶Î )
È磺
select to_char(name),price from aa
union all
select  to_char(name),price from bb
3Õűíaa,bb,cc¶¼ÓÐ name price ×Ö¶Î ²éѯ¼Û¸ñ×î¸ßµÄǰ3λÐÕÃû
select * from(select to_ch ......

oracle ÏÂÔØµØÖ·

oracle 9i
http://www.oracle.com/technology/global/cn/software/products/oracle9i/index.html
oracle 9i ÔÚÏßÎĵµ
http://download.oracle.com/docs/cd/B10501_01/nav/docindex.htm
oracle 10g/11g ÏÂÔØ
http://www.oracle.com/technology/software/products/database/index.html ......

OracleÖÐÎÄÈ«ÎÄË÷Òý

OracleÈ«ÎÄË÷ÒýµÄ»ù±¾ÖªÊ¶
Ò»¡¢ÀúÊ·±³¾°
OracleÊý¾Ý¿âµÄÈ«ÎļìË÷¼¼ÊõÒѾ­·Ç³£ÍêÃÀ£¬Oracle TextʹOracle9i¾ß±¸ÁËÇ¿´óµÄÎı¾¼ìË÷ÄÜÁ¦ºÍÖÇÄÜ»¯µÄÎı¾¹ÜÀíÄÜÁ¦¡£Oracle TextÊÇOracle9i²ÉÓõÄÐÂÃû³Æ£¬ÔÚOracle8/8iÖÐËü±»³Æ×÷Oracle interMedia Text£¬ÔÚOracle8ÒÔǰËüµÄÃû³ÆÊÇOracle ConText Cartridge¡£
¶þ¡¢Oracle Text Ë÷Ò ......

oracleÊý¾Ýµ¼³ö/µ¼Èë


ÔÚpl/sqlÖÐʹÓÃexp/imp¹¤¾ßʵÏÖoracleÊý¾Ýµ¼³ö/µ¼Èë
Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³ ......

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

Õâ¸öÆäʵºÜ¼òµ¥£¬²»¹ý×Ô¼º¾­³£Íü¼Ç£¬ËùÒÔ¼ÇÏÂÀ´
    sqlplus /nolog£»
    connect / as sysdba
    alter user sys identified by password£»
    alter user system identified by  password£» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ