Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì

OracleÖÐʹÓÃIMP DosÃüÁî µ¼ÈëDICÊý¾Ý¿â±¸·Ý¹ý³Ì
 
1.ʹÓþßÓн¨Á¢±í¿Õ¼äºÍÓû§È¨ÏÞµÄÓû§µÇ¼Oracle£»
2.½¨Á¢ÐèÒªµÄ±í¿Õ¼ä£»
3.½¨Á¢ÐèÒªµÄÓû§£¨Óû§Ãû£¬ÃÜÂ룬ĬÈϱí¿Õ¼ä£¬ÁÙʱ±í¿Õ¼ä£¬È¨ÏÞ£©
4.´ò¿ªDOS´°¿Ú£¬ÔÚÃüÁîÐÐÖÐÊäÈëIMP£»
5.ÓõÚÈý²½Öн¨Á¢ºÃµÄÓû§µÇ¼Êý¾Ý¿â£»
6.ÊäÈëDICÎļþµÄÍêȫ·¾¶£¬°´ÕÕÌáʾѡ ......

Oracle IOÎÊÌâ½âÎö

Oracle IOÎÊÌâ½âÎö
Êý¾Ý¿âµÄ×÷ÓþÍÊÇʵÏÖ¶ÔÊý¾ÝµÄ¹ÜÀíºÍ²éѯ¡£ÈκÎÒ»¸öÊý¾Ý¿âϵͳ£¬±ØÈ»´æÔÚ¶ÔÊý¾ÝµÄ´óÁ¿¶Á»òÕßд»òÕßÁ½ÖвÙ×÷¶¼´óÁ¿´æÔÚ¡£IOÎÊÌâÒ²ÍùÍùÊǵ¼ÖÂÊý¾Ý¿âÐÔÄÜÎÊÌâµÄÖØÒªÔ­Òò¡£ÔÚÕâÆªÎÄÕÂÖУ¬Ö÷Òª°ïÖú´ó¼ÒÔÚÀí½âOracleµÄ¶Áд²Ù×÷»úÖÆµÄ»ù´¡ÉÏ£¬Áé»î½â¾öÓöµ½µÄ¸÷ÖÖ³£¼ûµÄIOÎÊÌâ¡£
1 OracleÖÐIOµÄ²úÉú
IOµ±È»°üÀ ......

OracleÖÐOradim¹¤¾ßµÄÓ÷¨

´´½¨Àý³Ì£º
-NEW -SID sid | -SRVC ·þÎñ [-INTPWD ¿ÚÁî] [-MAXUSERS ÊýÁ¿] [-STARTMODE a|m] [-PFILE Îļþ] [-TIMEOUT Ãë]
±à¼­Àý³Ì£º
-EDIT -SID sid [-NEWSID sid] [-INTPWD ¿ÚÁî] [-STARTMODE auto|manual] [-PFILE ÎļþÃû]      [-SHUTMODE a|i|n]     [-SHUTTYPE srv ......

oracleÖ´Ðмƻ®


oracleÖ´Ðмƻ®Ïà¹Ø¸ÅÄî http://blog.csdn.net/wh62592855/archive/2009/11/06/4778343.aspx
 
1.     Ê²Ã´ÊÇÖ´Ðмƻ®£¿ÎªÊ²Ã´ÒªÁ˽âÖ´Ðмƻ®£¿
ΪÁËÖ´ÐÐÒ»ÌõsqlÓï¾ä£¬oracle¿ÉÄܱØÐëÒªÖ´ÐÐijЩ²½ÖèµÄ²Ù×÷£¬Ã¿Ò»²½Öè¿ÉÄÜÊÇ´ÓÊý¾Ý¿âÖÐÎïÀí¼ìË÷Êý¾ÝÐУ¬»òÕßÓÃijÖÖ·½·¨×¼±¸Êý¾ÝÐУ¬¹© ......

×îÐÂoracle ²¹¶¡ÏÂÔØ


×îÐÂoracle ²¹¶¡ÏÂÔØ
ʹÓÃѸÀ×н¨ÈÎÎñÏÂÔØµØÖ·Ìîд
ftp://updates.oracle.com/<patch_num>/p<patch_num>_<version>_<os>.zip
¾Í¿ÉÒÔÏÂÔØµ½ÄãÏëÒªµÄ²¹¶¡ÁË¡£
ÒÔÏÂÊǼ¸¸ö³£Óò¹¶¡µÄÏÂÔØµØÖ·¡£
(10.2.0.3 patch)
ftp://updates.oracle.com/5337014/p5337014_10203_WINNT.zip ftp://updates.o ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ